Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
JustinDoh1
Post Prodigy
Post Prodigy

How to expand all remaining rows horizontally from second (certain) row

I am sharing my PBIX file here.

 

I am trying to display all rows as shown below when I click the second row (Expand).

That means: when I click "Expand" (like D or E), all other rows / remaining fields would display horizontally at the same time like case below where I do not have to click each row to display/open all rows of data outcome horizontally.

 

JustinDoh1_0-1675887845262.png

 

This is how visual is structured using Matrix:

JustinDoh1_2-1675888450946.png

 

What I did/learned from my co-worker was, I set the Stepped layout as "Off" on the Row headers --> Options  --> Stepped layout (to make somehow works).

But, nothing else was done.

JustinDoh1_1-1675888028458.png

It works if I tried to expand all rows and save the PBIX file as last mode/status.

But, other than the behavior due to saving in that mode, it does not expand (if I try from the first time) automatically.

 

I am using Matrix for this visual.

Do I have to use other visual (other than Matrix) to make this work (expand all the way for all rows)?

 

I am trying to replicate something that works in Excel to PowerBI, but I am not sure it is possible.

 

Thanks.

 

1 ACCEPTED SOLUTION

@AllisonKennedy 

I think I got the solution without using measures.

I had to do this to make it work.

JustinDoh1_1-1675897406197.png

 

 

View solution in original post

5 REPLIES 5
AllisonKennedy
Super User
Super User

@JustinDoh1 

The only solution I have come up with for this issue is to create a Measure for the values you want expanded. Note this only works if you're already at the lowest level of granularity and 'expanding' will just give 1 row for each.

 

Create measures for selected values:

 

Deficiency Category Selected = SELECTEDVALUE(Table[Deficiency Category])

 

Then add those selected measures to the matrix in 'Values' and they won't need expanded. 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

@AllisonKennedy 

I think I got the solution without using measures.

I had to do this to make it work.

JustinDoh1_1-1675897406197.png

 

 

@JustinDoh1  That's a good alternative - I didn't think of that. May just need to add a note to the report as End Users will change frequently and they won't know that trick either. 🙂 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

@AllisonKennedy 

Thank you for your feedback.

I am still having a hard time making this work.. Somehow, when I put the measure into the Values area, values get duplicated.

JustinDoh1_0-1675895586056.png

 

@JustinDoh1 

Ah, yes, as soon as you have multiple measures in Values AND something in columns too you get too much info going on, so either need to create explicit measures for everything (not ideal) or use your wonderful solution! 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.