Forum Discussion

tanehome1's avatar
tanehome1
Icon for Helper I rankHelper I
10 months ago
Solved

Hide or show Table visual columns based on another slicer selection/filter

Greetings All, is there a way to control show or hide column in the table visual based on selection on another slicer Example: I've one slicer shows many types (type1,type2,type3) ex. type1 should...
Need Help
  • danextian's avatar
    danextian
    10 months ago

    Hi tanehome1 

    You can still use the field parameter table but you'll need create another with the information as to what columns are visible for each type.  This also calls for a many to many relationship between the  parameter and the view tables.

    Please see the attached pbix

danextian's avatar
danextian
Icon for Super User rankSuper User
10 months ago

Hi tanehome1 

You can still use the field parameter table but you'll need create another with the information as to what columns are visible for each type.  This also calls for a many to many relationship between the  parameter and the view tables.

Please see the attached pbix

tanehome1's avatar
tanehome1
Icon for Helper I rankHelper I
10 months ago

Hi danextian,

thanks for your reply,

actually it works fine but i have to make another relation with the main table to show the related data accordingly.