March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi All,
I need help to understand how can I add collapse button in a Power Bi Matrix table on Row Header like i have in Tableau. Below is the snapshot of Tableau format that i have and then need to apply the same in Power Bi.
Item Nbr and Item Name column is in the hierarchy and it collepse into one and hides Item Name. However, in Power Bi it does not apply. I get +/- icons button which applys on each row and hides only one row. I need this to be applicable on the entire column level. Can anyone please help?
Tableau table Before Collapse - it has Item Name in front of Item Nbr.
Tableau table After Collapse - Now Item Nbr is showing and it hided Item Name after collapse and appled on entire Column which is correct.
Power Bi Matrix table before collapse - here the collapse button (-) is showing on each row which should only show on Column Header (with Item Nbr only) and once i collaspe it it applies only on a single row, however, it should apply on entire column like Tableau.
Power Bi Matrix table after collapse - it hided the entire row not the entire column like it worked in tableau. It should behave the same way like tableau.
Thanks for the help, that i am aware of. my question was how i can have the same functionlity to collapse or expend the row entirely like we have in Tabluea... Please refer the snapshot that i added.
While clicking on the - button it collapse only one row, however, in Tabluea it collapse entire column.
Hi @kasai16
Power BI's matrix doesn't support such behavior, and if this feature is important to you, you can propose an idea about this, you can submit your idea by going to the link below:
Home (microsoft.com)
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @kasai16
When you hover over the top right of the visual you some icons will appear and on the 3 icons on the left side of these are the hierarchy options that expand and collapse all rows or columns
Joe
Proud to be a Super User! | |
Date tables help! Learn more
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
128 | |
90 | |
75 | |
56 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |