Selected filter compare previous selected filter values percentage is less than Red color other gree

[Shanvitha_V]

Hi Team,

I have created 3month,6month,1year,5years filter and I have created DAX formula Percntage

I need Below formula:

Now If Selected filter compare previous selected filter values percentage is less than Red color other green,

else if selected and previous selected filter values percentage equal then yellow.

Thanks

Shanvitha_V

[v-yiruan-msft · Accepted solution]

Hi @Shanvitha_V ，

Are you trying to apply conditional formatting for percentage values? Do you have two filters in your report and compare the currently selected value with the value of the previous filter? Then apply the conditional formatting according to the following conditions:
If the currently selected value is less than the value of the previous filter, then set red
if the currently selected value is greater than the value of the previous filter, set green
if the currently selected value is equal to the value of the previous filter, set yellow

You can refer to the following link to configure the conditional formatting.

Apply conditional formatting in tables and matrixes

How to Apply Conditional Formatting in Power BI Tables

Best Regards