Forum Discussion
Show/hide overlapping table visual based on slicer selection
- Anonymous2 years ago
Hi,
Thanks for the solution davidding offered, and i want to offer some more information for user to refer to.
hello Anonymous , you can see the following steps to set the bookmards.
1.Create 4 table visuals, and put the related fields to the table visuals, then open the selection in View option.
2.Name the table visuals as "BU1, BU2, BU3, BU4" in the selection. then put them to the same position.
3.Then for the first bookmark BU1, we need to display BU1 table visual, and hide the other three table visuals.
Then set it as a bookmark and name it BU1
Then for the bookmark BU2, we need to display the bu2 table visual, and hide other three table visuals.
Then add the page as a bookmark and name it BU2.
Then refer to the steps above to set the bookmark BU3 and BU4.
After setting them done, in 'Insert' option, select buttons->navigator->bookmark navigator.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
should consider calculation groups, with group items BU1, BU2, BU3, BU4.
Introducing Calculation Groups - SQLBI
Create calculation groups in Power BI (preview) - Power BI | Microsoft Learn
The DAX in each item should be:
item_x = calculate(selectedmeasure(), BU = BUx)
In the dashboard you can add a slicer with the items. The table can contain the normal columns.