Forum Discussion

j0710's avatar
j0710
Frequent Visitor
2 years ago
Solved

Dynamically Expanding Table in Power BI Based on Slicer Selection

In my Power BI report, I have encountered a challenge where I need the table to dynamically expand based on the values selected in a slicer. Here's the scenario:     Initial Table Co...
  • j0710's avatar
    2 years ago

     olgad 

    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

  • j0710's avatar
    2 years ago

     "
    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