I have a matrix I am building out.
I want to add about 20 different metrics/values to it.
About 10 should show up under the "column" option, the other 10 will have no column option applied to it.
So, for the example below, 10 metrics would apply to all purpose bike stand, awc logo cap and bike wash dissolver, while the other 10 should be a total metrics for product name: promotion category.
It would be ideal if I could add all 20 metrics into the matrix build out and then have the metrics only show up if applicable.
For example, I created a simple measure to show up as blank when not under AWC logo cap. But it still shows the blank column.
Is there a way to tell the matrix visualization to not display blank columns/measures?
@Anonymous, unfortunately, there is no way to hide columns but there is a workaround in another post, see if that works for you.
I would 💖 Kudos 🙂 if my solution helped. If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
Fabric Community Update - July 2025
Find out what's new and trending in the Fabric community.
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.
