Forum Discussion
Repeat Row Labels(Headers) in Metrics
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
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
4 Replies
- v-diye-msft
Community Support
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
- amitchandak
Super User
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
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!
