cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Manal Frequent Visitor
Frequent Visitor

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 3
wonga Established Member
Established Member

Re: Slicer to Cover Different Data Sources

@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 Frequent Visitor
Frequent Visitor

Re: Slicer to Cover Different Data Sources

@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 ?

 

 

Highlighted
wonga Established Member
Established Member

Re: Slicer to Cover Different Data Sources

@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.

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors