Forum Discussion
Highlighting Selected Show in Bar Chart
Hi All, Does anyone know how can you highlight a bar in a barchart with a dropdown filter, without hiding the rest of the values/bars Please let me know if you need any more information, as ...
Hi Anonymous ,
In your measure you are not comparing nothing so the result is not getting the highlith you need.
Measure = SWITCH(TRUE(),SELECTEDVALUE('Processed Data'[Title]) = SELECTEDVALUE(TAble[Slicer]),"#800000")I have added a part of the formula that you need to compare with the slicer you have.
Hi MFelix,
Thanks so much for this, I am relatively new to Power BI and Dax but this has helped a lot!
However, unfortunately I am having some issues; this is my version of the measure:
Measure = SWITCH(TRUE(),SELECTEDVALUE('Processed Data'[Title]),"#800000")
Then in the Data Colors I changed the conditional formatting to "Format by Field Value" then based on the field "Title" (I chose First as it had to be either First or Last). However, the table pops up with a yellow warning sign now and the bars haven't changed colours. The warning says "We found a value we don't recognise for default colour" - I looked up the colour sopecifically so I believe it is one, do you have any idea how I can fix this?
Thanks
MFelix
Super User
Super UserHi Anonymous ,
In your measure you are not comparing nothing so the result is not getting the highlith you need.
Measure = SWITCH(TRUE(),SELECTEDVALUE('Processed Data'[Title]) = SELECTEDVALUE(TAble[Slicer]),"#800000")I have added a part of the formula that you need to compare with the slicer you have.