Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I am trying to figure out how to only show columns that have data associated with it. In this case below, I have a filter on the page where you can pick the "Asset", and then under "Ownership", it will then show you the percentage of ownership by company. I only want to show the companies that own a % of the asset and want to hide the columns that have 0% ownership (highlighted in yellow). Any tips on how to do this?
Hey @Deedubpee, I imagine that this could be done if you flatten that portion of your data and switch to the matrix value. If you can provide a sample sanitized .pbix file (here's how), I can try to help.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |