%GT percentage of grand total - conditional formatting

[LLukas]

Hi Can you please advice on following?    I have result values in percentage in column in Matrix Visualization  (I used Show values as percent of grand total in Matrix Visualization) How can I get  conditional formatting of those values in percentage (for example different colours in backround)?

[Anonymous]

Hi @LLukas ,

Please show more details. What kind of conditional formatting you want, format by color scale or rule?

If you want to format by rule, you will need to create a measure for the percentage of total and use this measure as rule.

Best Regards,

Jay

[amitchandak]

@LLukas , conditional formatting should work base on measure value.

Another way is create a color measure like example and use that in conditional formatting with " Field Value" Option

Color Date =
var _min =minx(allselected(Date,Date[Year])
return
Switch( true(),
FIRSTNONBLANK('Date'[Year],year(TODAY()))-_min =0 ,"lightgreen",
FIRSTNONBLANK('Date'[Year],year(TODAY()))-_min =0 ,"blue",
"red")

if(FIRSTNONBLANK('Table'[Value],"true")= "true","green","red")

if(FIRSTNONBLANK(date[date],blank())= today(),"green","red")
if(max(date[date])= tofay(),"green","red")

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

Can you share sample data and expected output?