Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
104 | |
104 | |
89 | |
66 |