Show/hide overlapping table visual based on slicer selection

[Brij]

Hello Community, 

I have 4 table visuals (possibly more in the future) on top of each other (overlapped): all have different sets of columns coming from the same table. We can consider all the different tables (table visuals) holding relevant business unit information.

I would like to display the only single table visual when I select one of the slicer values (that shows the business unit name), again coming from the same table. 

Example:

I have a slicer 1 that contains values as per below:

BU1

BU2

BU3

BU4

I have 4 table visuals that contains relevant business unit information as per below:

• Table visual BU1
  • column1
  • column2
  • column3
• Table visual BU2
  • column4
  • column5
  • column6
• Table visual BU3
  • column7
  • column8
  • column9
• Table visual BU4
  • column11
  • column12
  • column13

All these 4 table visuals overlapping on each other and only one should enable / active based on slicer 1 selection.

Bearing in mind, I have other slicers on the report page that narrow down the data on the above table visuals should work as expected.

I tried with the bookmark but it does not work as expected.

How can I do it.

Any help is appreciated.

Thanks a lot

[v-xinruzhu-msft · Accepted solution]

Hi,

Thanks for the solution @davidding  offered, and i want to offer some more information for user to refer to.

hello @Brij , 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.

[Brij]

Thanks for the detailed explanation.

However, it seems the bookmark solution will not work out in this scenario as I will have few other filters on the page so the slicer 1 (in my example above) would change it's value (based on other filters applied on the page) and in some cases it may show only 'BU1' and 'BU2' or any other combination! How would that works out with bookmark solution?

It would be appreciated if you could provide detailed explanation as you did previously.

Thank you,

Brij

[davidding]

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.