The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
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.
User | Count |
---|---|
77 | |
75 | |
36 | |
31 | |
28 |
User | Count |
---|---|
95 | |
81 | |
55 | |
48 | |
48 |