Forum Discussion
Power BI Parameters
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
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
1 Reply
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