Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
You could achieve this using buttons with bookmarks and stacked visuals.
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
Hi @Anonymous
Now it looks impossible to change visual fields set with slicer in Power BI
User | Count |
---|---|
93 | |
83 | |
77 | |
70 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |