Hide column based on slicer selection

[Anonymous]

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:

Layer	Table name	count	Status
ingestion	Employee	800	S
ingestion	Student	600	S

Select Integration layer in slicer:

Layer	Table name	Count
integration	Employee	300
integration	Student	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.

[v-alq-msft · Accepted solution]

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.

[Greg_Deckler]

You could achieve this using buttons with bookmarks and stacked visuals.

[amitchandak]

I think you have to use bookmarks for that

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

You can change slicer value like

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

[az38]

Hi @Anonymous 

Now it looks impossible to change visual fields set with slicer in Power BI