Forum Discussion
Visual using Multiple Data Sets based off Slicer
Hi There,
I have two data sets that I am trying to show in a Dashboard, though depending on what we are reporting on for that month I want the visual to change between the two data sets
ie: one month we are looking at Data set A and the next month (using the slicer) it would show Data set B.
I have tried this with buttons to hide the visual we are not using, though I want it to effect all the same sections across multiple tabs so thought this would work
Can anyone help with this?
3 Replies
Hi aausten22
Are you referring to Dashboard as Report or as what Power BI defines it (a collection of tiled visual from different reports)? If it is the former, have you tried combining both tables into one for simplicty? You can add a custom column to identify which rows in the combined table are from data A/B.
Hi There,
It is a dashboard in the form of what Power BI determines it. I can try the column though I am using around 5 different data sets across the whole thing so wanted to see if they can be controlled by a slicer rather than having to use a button to switch the bookmarks for the visuals
When you go to the workspace, which Icon is for your dashboard/report? The one in red is for dashbaord. The rests are for a report. If it is indeed a dashboard then I dont think you can control them with a slicer.
