Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
I got a table visual which contains 7 columns in it as shown in the figure:
I want to conditional formatting at the row level of the table in such a way that if older than 18 months and older than 15 months have 1 value then the background colour of the whole row should be red, if older than 15 months has 1 but older than 18 months has 0 then it should be blue otherwise it should be lightgreen. Based on the requirement, I wrote the following measure:
CF - 15 month =
When I clicked ok, it only changes the font color of the Derived case no column as shown in the figure
Is there anyway I could apply the measure at the row level instead of column level?
Solved! Go to Solution.
Hi @Dunner2020 ,
Currently, it is not supported to apply conditional formatting for whole rows in table/matrix visuals in Power BI.
Here is a similar idea: Microsoft Idea · Conditional Formatting - Whole Table Rows (powerbi.com).
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Dunner2020 ,
Currently, it is not supported to apply conditional formatting for whole rows in table/matrix visuals in Power BI.
Here is a similar idea: Microsoft Idea · Conditional Formatting - Whole Table Rows (powerbi.com).
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Dunner2020 , No. Apply on same on all the columns
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |