Forum Discussion
Dynamically changing slicers with Connection Live
Hi Community! I have a perfect tabular model which is a star schema. In the report, I have slicers: (1) If I select a dimension, (2) will dynamically change only for dimensions which depends ...
stokkris , If the live connection is created on Power BI Dataset , then enhance the Dataset to have field parameters
Field parameter with power bi dataset live connection?- https://youtube.com/shorts/slpTlY9QKzg
If not then you have to consider bookmarks and buttons
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks
amitchandak Unfortunately semantic model is published via xmla endpoint in Visual Studio so I can't add field parameters.
Main table on report contain 40mln rows hence multiplying for bookmarks will slow the report.
I was thinking more of additional virtual tables and dax.