Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |