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 on the (1).
(3) If I select a dimension, (4) will dynamically change only for dimension which depends on the (3).
So the thing is - if I select for example "division" in (1) then show in slicer (2) dimension from division table, if I select "unit" then show in slicer (2) dimension from unit table and so on, slicer shows data from different tables. This acts the same on (3) and (4).
Example of data model
Fact Table is 40 mln rows (its more like a central dimension table not real fact)
Dimension tables are 100-5000.
Report contain only one table with dimensions (no measures, just display columns), the first column also is displated dynamically depends whats filtered on slicers and then change for particular dimension table.
How can I manage that without using field parameters because the report is in Connection Live mode. I can't use composite model either.
2 Replies
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-bookmarksamitchandak 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.
