Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello everybody,
I have 3 different line areas in my matrix. I would like to give the first line area header a different color. How does it work?
Same problem for me. Pretty lame to be honest and makes me look like I don't know how to do my job, when it's (another) product limitation. The feedback from the end users is 'but that doesn't make any sense...'. Which is all one can say about it other than 'you don't get this with Tableau...' which is another comment i've heard.
Even, currently with Matrix visual, if you want to change the color of ONLY upper row header color(text), you should set the 'Style presets' back to 'Default'. Otherwise, the entire row headers color will change altogether.
For example, when you choose 'Minimal' or 'None' in Style presets, entire row headers' color changes at once, which is a weird behavior. Be careful;;
This limitation is just embarrasing as a report writer. I can conditionaly format every value in the matrix exept the row headers.
I'm just at a loss. I just dont care about all your new features anymore. If the reports dont look good then the back end doesn't matter. This is a great example at the lack of attention from the PBI development team to formatting visuals. I want to be a fan of PBI but this is just pushing me to find and adopt other BI solutions. I've been patient for years, I've had enough.
same problem I still need an option in row headers to allow using the colour of values...or conditional format
Thanks for your feedback. Unfortunately, this does not quite meet customer requirements. As I understand it, there is no way to highlight individual groups of lines in color. Are there any other matrix visuals from the store that can do more in this case?
Hi, @Anonymous
As mentioned by @amitchandak ,If you just want to change then color of head, you can change the font color\background color of row headers in "Format Pane".However, it will applied to all subtotal headers.
You can consider using conditional formatting to formate row value as below:
Conditional formatting = IF(HASONEVALUE(Table1[Segment]),"","lightblue")
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
141 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
73 | |
66 | |
60 |