Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
This is how visual is structured using Matrix:
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.
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.
Solved! Go to Solution.
I think I got the solution without using measures.
I had to do this to make it work.
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.
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
@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. 🙂
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
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.
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!
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
64 | |
52 | |
47 |
User | Count |
---|---|
216 | |
89 | |
76 | |
67 | |
60 |