Forum Discussion
How to format Column Header when using Display Parameter
Hi mbudiman ,
Just wanted to check if the responses provided were helpful. If further assistance is needed, please reach out.
Also if you have submitted an idea in the Ideas Portal, please feel free to share the link here so others in the community can upvote it. With enough support, Microsoft may consider it for future implementation.Thank you.
Hi mbudiman
Technically, the functionality you are asking for does not exist in Power BI at the moment.
Because when using a display parameter the measures are combined into a single column header element inside Columns, both filtering and formatting of individual headers are not possible. Any formatting applied to the header is uniform.
There are a few alternatives you could explore:
You can support the community idea here and vote for it:
You can also look at paid third-party visuals that offer much more flexible table styling, such as:
From a UX perspective:
In your screenshot, the matrix uses around six different colors. This creates very high cognitive load for the reader. On top of that, the logic of the colors is not self-explanatory, so they don’t really add value. Eventually, every extra element like colors, bold fonts, repeated dollar signs, etc. consumes attention and creates real eye strain.
I strongly recommend testing a cleaner approach:
Use light gray fonts for values.
Black or bold gray only for subtotal/summary headers.
Reserve strong colors only for the critical KPI (for example, highlight negative results in red).
Below is an example I prepared for one of my talks, showing how a busy, colorful table can be simplified into a clean version. I suggest you make the same experiment yourself—compare both versions and check in which one you can more quickly identify the issues that need attention. You may find that the clean approach is far more effective.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly