Skip to main content

Hello,

 

I have a question regarding my chart. I would like to change the color of a binned bar relating to a specific user id.

 

As an example:

 

When I select a specific user ID for example "111085" through the filter option. I want to highlight the bar that represents my user ID with a different colour than blue. So I can compare myself easily to the other ID`s.

 

Thanks in regard

 

Highlight one bar chart based on binned values

2 answers
  1. Feb 24, 2020, 7:36 PM

    here is a way to do it

    this just totals the sales at the customer name

     

    here is a way to do itthis just totals the sales at the customer name then use that to create bins the create a histogram using the lod I added a set on state and included all the state to have a unif

     

    then use that to create bins

     

    pastedImage_1.png

    the create a histogram using the lod

     

    I added a set on state and included all the state to have a uniform blue bar total

    pastedImage_2.png

     

    add another sheet with just the cust name - you are going to use it with a Highlight action

     

    pastedImage_3.png

    then create a dashboard and add a highlight action

     

    pastedImage_4.png

     

    pastedImage_5.png

     

    Jim

    If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

0/9000