Repeat Row Labels(Headers) in Metrics

[Anonymous]

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

[v-diye-msft · Accepted 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 

[harshnathani]

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!

[Anonymous]

Thanks for the help. But table wont allow me collapse expand option(drill up/down).

[amitchandak]

@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