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.
When using the drill-down feature in a matrix, is there a way that I can use different colors for different row levels? For example, in this matrix, I'd like the State to be light gray, the Year to be dark gray, and have the rows of the lowest level, the Lead, alternate white and green. Is there a way to do that?
Solved! Go to Solution.
Thanks. This doesn't help here because I need the entire row highlighted, including the row header, to which I can't apply conditional formatting. But it sounds like that isn't possible in the current edition of Power BI.
Hi @Anonymous ,
Based on my test, we cannot get the excat same result as you excepted. However we can create a measure and make the filed formatted by the measure to work around.
Measure 2 = IF ( ISINSCOPE ( Table1[Year] ) && ISINSCOPE ( Table1[name] ) = FALSE (), "#FF009B", IF ( ISINSCOPE ( Table1[State] ) && ISINSCOPE ( Table1[Year] ) = FALSE (), "#374649", "#F0E2FF" ) )
Thanks. This doesn't help here because I need the entire row highlighted, including the row header, to which I can't apply conditional formatting. But it sounds like that isn't possible in the current edition of Power BI.
Hi @Anonymous ,
You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
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 |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |