Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Is there a way to hide a specific row from a matrix?
From the image below, I would like to be able to hide/zero out the child rows of Wages for Home Office Department while retaining the rolled up value. I would like to be able to expand all of the other Parent/Children rows normally. Any ideas?
Solved! Go to Solution.
You would have to remove that level of detail in your source data. It will still show as BLANK() though. Ragged hierarchies are not supported in the matrix visual.
You would have to remove that level of detail in your source data. It will still show as BLANK() though. Ragged hierarchies are not supported in the matrix visual.
Thanks. Are there any other visuals that will support this option?
So basically would need to use a SWITCH (or some other function) in Query Editor?
This one supports ragged hierarchies
Warning - it will be very slow with anything above 10K granularity in the levels. Understandably so as it needs to traverse the whole tree to decide what to show and what to hide.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!