Forum Discussion

KD13's avatar
KD13
Helper I
4 years ago
Solved

Conditional Formatting on Matrix - Not working when i drill down

Hi All,

 

i'm facing an issue with Matrix conditional formatting in PBI.

Actually, i have a rule wich shows green bar when positivie value and red bar if negative value.

it works fine on the first level of the row :

 

 

but when i click on the + icon to see deviation by product it won't work.

 

could you please support me ? Thanks !

 

Need Help
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi KD13 

    Is the percentage column in the visual below all empty values? Could you share the measure code and some sample data for us to further check? Thanks

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • speedramps's avatar
    speedramps
    Super User
    4 years ago

    If you look at the drill down screen shot you can see the deviation column is blank.

    In which case your DAX measure is wrong. Not necessarily the conditional formatting. If deviation value is null then it is neither +/- blue or red.

    Provide examples data and dax measure so we can help

     

     

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi KD13 

    Is the percentage column in the visual below all empty values? Could you share the measure code and some sample data for us to further check? Thanks

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.