Forum Discussion
JustinDoh1
Post Prodigy
Post ProdigyHow 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 f...
AllisonKennedy
Community Champion
Community ChampionThe 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.
JustinDoh1Post Prodigy
Post Prodigy- AllisonKennedy
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. 🙂