Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
Am new to Power BI, please assist I am looking for a guideline on the following issue:
1. I have a dashboards that reports summary only with filters in it, now I want to call another dataset and display a different visual when a specific filter from dataset 1 was choosen how do i go about doing this please assist.
Thank you.
Regards
Narty
Solved! Go to Solution.
Hi @narty,
I don't think you can direct switch dataset on power bi service based on slicer or other filters.
If you means use slicer/filter to switch source table, it is possible to achieve.
Source tables:
calendar, T1(data from 2015),T2(data from 2016) T1,T2 has relationship to calendar.
Steps:
1. Create a table as source for slicer.
Select Table = VALUES('CALENDAR'[Date].[Year])
2. Write a measure to switch result based on slicer.
Dynamic Result = SWITCH(SELECTEDVALUE('Select Table'[Year]),2015,SUM(T1[Amount]),2016,SUM(T2[Amount]),0)
3. Create visual based on calendar date and measure.
Result:
Regards,
Xiaoxin Sheng
Hi @narty,
I don't think you can direct switch dataset on power bi service based on slicer or other filters.
If you means use slicer/filter to switch source table, it is possible to achieve.
Source tables:
calendar, T1(data from 2015),T2(data from 2016) T1,T2 has relationship to calendar.
Steps:
1. Create a table as source for slicer.
Select Table = VALUES('CALENDAR'[Date].[Year])
2. Write a measure to switch result based on slicer.
Dynamic Result = SWITCH(SELECTEDVALUE('Select Table'[Year]),2015,SUM(T1[Amount]),2016,SUM(T2[Amount]),0)
3. Create visual based on calendar date and measure.
Result:
Regards,
Xiaoxin Sheng
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |