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.
Can I format Row background colors in Matrix table?
I need matrix table visuals like in the below example, where Product and Country are in ROW and Months in Column.
Sales in VALUES.
I have no problem to use conditional formatting for Sales, but I cannot make country column formatted accordingly as its value sits in Row of matrix table, but value.
Is it possible at all to do in PBI?
Thanks in advance!
Solved! Go to Solution.
Hi @Sbezkoro ,
To my knowledge , It is not possible to perform row conditional formatting currently. You could register an idea for it or vote for the idea.
Unfortunately, you can only apply conditional formatting to values, totals, or both. It is also not possible to use color based on a calculation, you may apply the colors for the selected column, and base the formatting on the Field value of the column.
For more information, you can refer to:Use conditional formatting in Power BI
Please see if the similar thread helps:Conditional format Row Text Matrix Table
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Sbezkoro ,
To my knowledge , It is not possible to perform row conditional formatting currently. You could register an idea for it or vote for the idea.
Unfortunately, you can only apply conditional formatting to values, totals, or both. It is also not possible to use color based on a calculation, you may apply the colors for the selected column, and base the formatting on the Field value of the column.
For more information, you can refer to:Use conditional formatting in Power BI
Please see if the similar thread helps:Conditional format Row Text Matrix Table
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@Sbezkoro , You can create a color measure and use that. But you can use that only for values column not for rows/columns
If(max(Table[Country]) = "PL", "Grey", "White")
How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
No, this is the thing, that there is not issue how to format Value fields, but columns or rows.
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |