Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
Hi,
Here's my suggestion:
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |