Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Conditional Formatting with using Dimensions in Dax Measure

Hi community,

 

I've a specific issue. I'd like to create a measure to control the colouring of my visual. 

As you can see below I'm trying to say if my measure is less than 0 AND my KPI is 1 than do this or do that. 

I tried to get this work with calculated colums. No errors were shown but it didn't work at all.

 

Need Help

4 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    6 years ago

    is this a matrix?  are you using the conditional formatting?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Vanessa,

       

      yes, this is a matrix and I'm trying to use the conditional formatting based on a measure. 

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi Anonymous ,

     

    I have tested on my side and it works well. If "KPI" is a column, you need to use MAX()/MIN()/... to specify the current row.

    You can refer to this post to set Conditional formatting of Matrix visual in Power BI.

     

     

    Best Regards,

    Icey

     

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

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Is this problem solved?


    If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.


    If not, please let me know.

     


    Best Regards
    Icey