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:

     

     

MFelix's avatar
MFelix
Super User
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: