Forum Discussion

Manal's avatar
Manal
Regular Visitor
10 years ago

Slicer to Cover Different Data Sources

Hello,

 

I know that I can create a slicer from a column on my dataset table so that I can filter my table data. And that I can use the visual interaction option within the same report.

But what I need is to have a dashboard where I have slicers that can filter all or some of my visuals from different reports.

Is there a way I can do that?

Also can I create slicers from different datasources (or dataset tables) so that I have for example a "Years" or "Departments" table I can use everytime I have dasources that have these columns.

 

Thank you.

 

 

3 Replies

  • wonga's avatar
    wonga
    Continued Contributor
    10 years ago

    Manal

     

    Slicers are designed to be used in Power BI reports, NOT in dashboards. The only way I know for slicers to work across different data sources is if a relationship(s) is(are) established between the data sources.

     

    Hope this helps, thanks.

    • Manal's avatar
      Manal
      Regular Visitor
      10 years ago

      wonga

      Thank you !

       

      I know that the Power BI desktop allows you to create relations between your tables but how do we do that on the Power BI service ?

       

       

      • wonga's avatar
        wonga
        Continued Contributor
        10 years ago

        Manal

         

        At this point in time, it doesn't look like relationships can be established on the Power BI service.

         

        As a general rule of thumb, if you want to get the most out of Power BI, it's best to do all the heavy lifting in Power BI Desktop.

         

        Power BI Service is more suitable for accessing cloud/online data sources like Google Analytics and the like.