Slicer enabling user to choose dataset for several visuals

[Anonymous]

Hi PBI community 😊, 

Users of my report would like to be able to choose between two different datasets for several visuals. They want to choose between two types of calculation rules/datasets depending on their needs. 

Is there a way to create a slicer to choose between two different datasets ? 

I was thinking of using bookmarks but this feature does not work well when the report is exported on upslide (powerpoint), which is needed by the users. 

Thank you for your help

Gaëlle

[jaweher899]

Yes, you can create a slicer to choose between two different datasets.

One way to achieve this is to use a disconnected table to create the slicer. A disconnected table is a table in the data model that has no relationship to any other table. You can create a disconnected table with two options, one for each dataset, and use this table as a slicer.

Here are the steps to create a disconnected slicer:

1. Create a new table with two columns, one for each dataset. Populate the table with the names of the datasets.

2. Create a measure that uses the SELECTEDVALUE function to choose the appropriate dataset based on the selection in the slicer.

3. Use this measure in your visuals instead of the original dataset.

4. Add the disconnected table to the report canvas as a slicer.

When users select an option in the slicer, the measure will dynamically switch to the corresponding dataset.

Note that the disconnected slicer approach may not work well when exporting the report to PowerPoint as it requires the data model to be embedded in the report. Another option is to duplicate the visuals and create a toggle button or switch to show the appropriate visual based on the selected dataset.