Forum Discussion

Shanvitha_V's avatar
Shanvitha_V
Frequent Visitor
4 years ago
Solved

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

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 percentag...
  • Anonymous's avatar
    Anonymous
    4 years ago

    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