Forum Discussion

jjjtr945's avatar
jjjtr945
Frequent Visitor
3 years ago
Solved

Dynamically Show/Hide Columns and Rows Based on Single Slicer Selection

I have data that has been collected from Microsoft Forms and has been uploaded to Power BI. With this data, I want to be able to create a dynamic matrix based off one slicer.   With this slicer sel...
Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    Hi jjjtr945 ,

     

    Believe the best option is:

    • Add an Index Column
    • Select the index and Product and unpivot other columns
    • Filter out the blanks

    Create your matrix with the following way:

    • Rows:
      • Index
      • Products
    • Columns:
      • Attribute
    • Values
      • Value
    • Turn off the step layout
    • Turn of wrap on all options
    • Reduce the size of the index column until is invisible:

     

     

Ritaf1983's avatar
Ritaf1983
Super User
3 years ago

Hi jjjtr945 

Columns can't be inserted based on conditions.
What you saw with field parameters
There is only one option to choose columns, and they must be chosen manually by the user.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly