The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
102 | |
82 | |
63 | |
57 |
User | Count |
---|---|
254 | |
119 | |
115 | |
100 | |
76 |