Forum Discussion

IEhrlich's avatar
IEhrlich
New Member
3 years ago

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