Forum Discussion
Dynamically Expanding Table in Power BI Based on Slicer Selection
Dear Olga Dontsova,
I wanted to take a moment to express my sincere gratitude for your assistance,
Your solution was incredibly helpful and provided valuable insight that has greatly benefited me in my work.Thank you once again for your support and assistance.
It is community members like you who make the Power BI community such a valuable resource for learning and collaboration.
pls connect linkedin : )
linkedin.com/in/jackson-s-652396240"
I would do it differently. No unpivoting, leave the columns as they were.Do you know field parameters? Modelling-New Parameter-Fields then pick all your columns that you would like to display.
Use this field parameter as a slicer and place it into the table. Can it be the table?? Matrix always summarizes, in your case it always took the first value. Why matrix shall be used??"
this solution by olgad
Post PatronThe Field Parameters solution in the accepted answer is the right approach much cleaner than unpivoting. One thing to add: Field Parameters work well for switching between fields, but they don't support showing a field AND its comparison value side by side dynamically (e.g., Revenue + Revenue vs Last Year in the same row).
For tables where users need to select which columns to show AND add variance between selected columns all in the published report Flexa Tables on AppSource combines both: column show/hide via field picker + built-in variance between any two columns