Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
aausten22
Helper I
Helper I

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 3
danextian
Super User
Super User

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.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

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.

danextian_0-1673480894436.png

 





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.