Conditional Formatting with using Dimensions in Dax Measure

[Anonymous]

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.

[Icey]

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

[Icey]

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.

[vanessafvg]

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

[Anonymous]

Hi Vanessa,

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