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 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
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 |
---|---|
107 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
139 | |
104 | |
104 | |
80 | |
66 |