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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors