Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Folks,
I am building a metrics visual and have two fields in rows. Is there any way to repeat row headers when I expand rows(drill-down). We can do this thing in Excel pivot table. I need same kind of visual in Power BI. Please to the screenshots for better understanding. Any help will be highly appreciated.
Note: I have disabled stepped layout and row subtotals.
Regards,
Sankalp
Power BI Metrics
Solved! Go to Solution.
Hi @Anonymous
It's not able to achieve in the matrix currently, you might consider adding the collapse expand option in the table by developing a custom visual.
https://docs.microsoft.com/en-us/power-bi/developer/visuals/custom-visual-develop-tutorial
Please also kindly raise it as an idea in the portal to bring the feature coming:
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Hi @Anonymous
It's not able to achieve in the matrix currently, you might consider adding the collapse expand option in the table by developing a custom visual.
https://docs.microsoft.com/en-us/power-bi/developer/visuals/custom-visual-develop-tutorial
Please also kindly raise it as an idea in the portal to bring the feature coming:
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Hi @Anonymous ,
I do not think this is possible.
Incase you want it to be displayed for all rows, you can switch to the Table Format.
Else have a look at the market place
https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals&search=matrix&page=1
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Thanks for the help. But table wont allow me collapse expand option(drill up/down).
@Anonymous , you have to check stepped layout
refer : https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |