Forum Discussion

jmamer's avatar
jmamer
New Member
5 years ago

Multiple row groups on same level in matrix drilldownundefined

Is there any way to have multiple row groups appear on the same level in the matrix drilldown hierarchy?   So, for instance, if a top level matrix looks like this (with Stepped Layout property set ...
Need Help
v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi , jmamer 

Maybe you can create  a new custom column  which merge these two columns( "State" and " State Bird").

Then  relpace the  two columns  with this new custom column in  the matrix visual.

 

Best Regards,
Community Support Team _ Eason

jmamer's avatar
jmamer
New Member
5 years ago

Thanks for the reply - but I'm looking for a solution that would allow me to keep them as two individual columns, I don't want one column with a concatenated string.

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    Hi , jmamer 

    I didn't find any related option in the matrix format pane .I'm afraid that it doesn't support  to expand all levels at once currently.

    For you requirement,you  can come up with a new idea and add your comments there to make this feature coming sooner. https://ideas.powerbi.com/forums/265200-power-bi-ideas 

     

    Best Regards,
    Community Support Team _ Eason