Forum Discussion
Conditional Formatting with Slicers
Hello,
I am attempting to apply conditional formatting to the below table, row-by-row. The dashboard includes slicers that lets the user select which country and state/province that they would like to view:
Below is the excel outcome that I am trying to create in Power BI:
When applying gradient conditional formatting through the visualizations formatting tools, the gradient is based on all values in the filtered data set, rather than individual rows as listed in the above screenshot. I have attempted to create a measure to apply the formating on a row-by-row basis, but have not had any luck so far. The visual needs to have conditional formatting applied based on the values selected on the slicer, and not be dependent on the values in the entire data set.
It also might be important to note that the values in the table are counts of unique identifiers in the data set.
Thanks in advance for any assistance.
1 Reply
- parry2kSuper User
IEhrlich I did a video on this long time ago, check it out here and tweak it as you see fit Developing Custom Gradient Color Scales for Columns in Matrix Visuals in Power BI: Part 1 - YouTube
👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️