Forum Discussion

aausten22's avatar
aausten22
Helper I
3 years ago

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: o...
Need Help
Tips and Tricks
danextian's avatar
danextian
Super User
3 years ago

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.

  • aausten22's avatar
    aausten22
    Helper I
    3 years ago

    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

    • danextian's avatar
      danextian
      Super User
      3 years ago

      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.