Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.