Conditional formatting for Total Label on stacked column chart

[iuli]

Hello, 

I used a measure to color the total label in red / green. For a matrix works ok, but not for total label. 

[iuli]

the attached picture shows how the conditional rule is appyed using the above color measure

[Anonymous]

Hi @iuli ,

Can I know that are the field Products_CY and Products_PY fact fields of the table or measures? If they are measures, could you please provide their formula? By the way, all of fields which apply on the stacked column chart visual are all from the same table? It is better if you can provide a simplified pbix file. Thank you.

Best Regards

[iuli]

Hello, 

Products_CY and Products_PY  are fact fields of the table , but I tested also with measures and had the same result. Please try to download the pbix file via this link : 

publicerep/test total label color.pbix at main · iulianalidia/publicerep (github.com)

Thank you !

[iuli]

Hi,

the measure is : 

color = SWITCH(TRUE(), SUM('Table'[Products_CY]) > SUM('Table'[Products_PY]), 1 , 0 ) // 1=red, 0=green

[amitchandak]

@iuli , can you share the color measure ?

refer, if needed

How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4