Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)?
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
@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?
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |