Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am developing a bar chart with month as a dimension. And I want to do is that when I select a particular month or n months, I want the data of those selected month to be highlighted without losing the rest of the data i.e. gray out the unselected months and highlight the selected month just like we do in List box.
Is there a way this could be achieved??
Use this as a Background Color expression by expanding your measure expression.
if(Month=Month,LightBlue(),LightGray())
Gaurav, did Lisa's post work as a solution for you? If so, please be sure to return to the thread and use the Accept as Solution button on her post to give her credit for the assistance and to let other Community Members know it did work for you. If you are still working on things, let us know where you are and what you still need to see if someone can come up with something further.
Regards,
Brett