Switching Dimensions based on slicer selection

[AshDil]

Hi,

I have 3 tables as follows:

Table 1:

Report

A

B

Table 2:

Segment	Amount
North	100
East	200
South	300
West	200
Central	400

Table 3:

Segment	Amount
North	100
East	300
Central	500

Now I will add report column from table 1 to slicer,

If 'A' is selected in slicer, I want to show segment and amount from Table 2

If 'B' is selected in slicer, I want to show segment and amount from Table 3

Please help me to do.

Thanks,

AshDil.

[Ashish_Mathur]

Hi,

Here's my suggestion:

1. In the Query Editor, add a Report column in Table 2 with all A's in that column
2. In the Query Editor, add a Report column in Table 3 with all B's in that column
3. Append Table 2 and Table 3
4. Create a relationship from the Report column of the appended table to Table 1.
5. Build your slicer from Table 1
6. Build your visual

[sevenhills]

Are you looking something like this?

https://powerbi.tips/2019/08/dynamic-visuals-using-buttons/

https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive 

[AshDil]

Hi @sevenhills ,

My requirement is near to above suggested one but not complete solution because in above mentioned the data is coming from same table but in my case the data comes from 3 different tables. So, Please suggest me to do.

Thanks,

AshDil

[v-easonf-msft · Accepted solution]

Hi,  @AshDil 

As @Ashish_Mathur said , you have to consider integrating the data from Tables 2 and Table3.
I have created a sample file for your reference. Hope it will help you.

If you consider this thread closed,please mark the helpful replies or add your reply as Answered to close this thread.Other community members will easily find the solution when they get the same issue.

Best Regards,
Community Support Team _ Eason