Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Hide column based on slicer selection

Hi All,

I have slicler with 2 values as ingestion and integration layer.When I select ingestion layer it should give me  total 4 columns and when I select the integration layer i need to get only 3 columns.Can we achive this in power bi.

select Ingestion layer in slicer:

LayerTable namecountStatus
ingestionEmployee800S
ingestionStudent600S

 

Select Integration layer in slicer:

LayerTable nameCount
integrationEmployee300
integrationStudent

200

 

whenever the user selects the integration layer the table should display only 3 columns, need to eliminate the status coulmn.How to achive this in power bi.

Need Help
Show and Tell
Tips and Tricks
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    Based on your description, It is unsupported to use a slicer to display and hide fields in a visual. As a workaround, you may achieve your requirement with bookmarks and buttons. I created data to reproduce your scenario.

    Table:

     

    You may create two buttons and two bookmarks as below.

     

    Then you need to make the button selected, go to 'Visualization' ribbon, check 'Action' on, set Type as 'Bookmark' and 'Bookmark' as the corresponding page. Finally you may Ctrl+click the button to go to the corresponding page.

     

    For further information, please refer the official document .

     

    Best Regards

    Allan

     

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

4 Replies