cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper V
Helper V

How to filter tiles on a dashboard in power BI service

Hi,

 

I have 2 visuals in a power bi desktop report page and a date slicer to filter this visuals but due to size issue I created a new page and add one visual in it.so now i have two page in which one have a visual and date slicer and other have a single visual.After publishing the report to service I added this visuals as a tile in dashboard but when i filter by date then only one visual get filtered and not the other so how can i filter all the tiles on a dashboard by a single filter.

 

Thanks,

Jat

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @jatneerjat,

 

It is a by design behavior that the slicer can only filter those visuals that are displayed on the same page. If you pin two report pages to dashboard as two tiles, the slicer selection won't affect the other one.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
Microsoft
Microsoft

Hi @jatneerjat,

 

Please be aware that:

It is not available to pin slicer to dashboard.

The pinned visual displayed on dashboard won't be filtered by the slicer selection displayed on source report page.

 

As a workaround, you could pin entire report page which contains slicer to your dashboard by selecting "Pin Live Page". This way, you can use the slicer to filter all tiles within the same report page.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yulgu-msft,

 

Thanks for your response.

 

I did exactly the same by pin entire report page to my dashboard but as i have multiple visuals so the visuals look very small in size so i distribute this visuals into two pages and then pin them as a tile on dashboard but the problem is only one tile gets filtered by my date filter(the page in which it is available) and not the other.so how can i show this visuals in desired size on dashboard and all visuals should be filterd by date filter.

 

Thanks,

Jat

Hi @jatneerjat,

 

It is a by design behavior that the slicer can only filter those visuals that are displayed on the same page. If you pin two report pages to dashboard as two tiles, the slicer selection won't affect the other one.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Thank You @v-yulgu-msft 🙂

Hi Yuliana Gu

 

I tried your work around, but it is not working.

 

when I alter my slicers after "Pin Live Page", only the slicer changes, and it does not impact any tiles

 

In my Desktop, when I alter the slicer, all of the visuals are updated on the other pages

Anonymous
Not applicable

That acctually beats the purpose of dashboard where you can present visualization/info from different pages and filter tiles quickly (assuming that your slicers on each page are in 'Sync' mode). What's the point of dashboard where you need to customize every single tile while you can can quicker jump between pages with sync slicers accross pages.

I'm just starting out with the Service, after upgrading to Pro recently.  I had assumed the Dashboard would do exactly what you're asking for - I want a place where customers can go and see current month data summaries from several reports.  It seems that can't be done at the dashboard level, so I'm going to create a 'report of reports' and pin that single page as a dashboard.  I guess that'll do the trick?

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors