Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |