Forum Discussion
Switching Dimensions based on slicer selection
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.
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
4 Replies
Hi,
Here's my suggestion:
- In the Query Editor, add a Report column in Table 2 with all A's in that column
- In the Query Editor, add a Report column in Table 3 with all B's in that column
- Append Table 2 and Table 3
- Create a relationship from the Report column of the appended table to Table 1.
- Build your slicer from Table 1
- Build your visual
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
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
