Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Daryl_K
Resolver II
Resolver II

New Filter Experience doesn't propagate to pinned pages?

I have multiple Power BI reports that all are working correctly. They all refresh once every 24 hours, and that has been working fine too. I was an early adopter of the New Filter Experience because it frees up so mcu screen real estate, but it seems using it there's no way to adjust filters on pinned pages from the reports.

 

My performance reports are a series of 12-month rolling average charts, graphs and analytics. At this point (early October) the reports themselves are all updated through end of last month, but all of my pinned live pages have date spans which appear to be when the report was first created! I enabled "Show time of last refresh" and it says within 24 hours, so it appears the data is updating, but no way to adjust the date range.

 

Kind of crazy! Is there no way to enable NFE on the dashboard itself, if we cannot get actual report filters to propagate through?

1 ACCEPTED SOLUTION

FOUND IT! There are options on each visual (in Desktop) to also disable the visual header. Corrected this and re-published my reports and now I can pin individual tiles.

 

Thanks!

View solution in original post

9 REPLIES 9
GilbertQ
Super User
Super User

Hi there

When you pin a visual or power bi report to a dashboard it pins it with the current filter applied.

If you had pinned it where you for example had selected the last 12 months manually being Sep 2018 - Sep 2019, then that is how the filters will be applied to the pinned report.

What you need to do, is to pin the reports where it has a column called last 12 months and when the dataset is refreshed it then moves with the dates, but the the column called last 12 months remains the same.

You can use this blog post below, where you can add in a column for "Last 12 Months" https://www.fourmoo.com/2016/09/07/create-dynamic-periods-for-fiscal-or-calendar-dates-in-power-bi/




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

I wish that were the case, because it might be a small PITA but I could at least get around it by re-pinning the page once per month (my data is in monthly sets). However, I tried re-pinning it, and even creating a new dashboard, but the pinned page always has the exact same date filters on it. I cannot be sure, but I think it was the dates the reports were first published (one ends last May)!

 

Is there a cache that might be holding this data?

 

"Last 12 months" sounds like it could work, assuming it can be set to work in whole months (i.e. at present it would end on September and not move forward to October until we are in November).

There might be some caching going on.

I know that it certainly works when pinning visuals to a dashboard.

I wonder if it is different when pinning an entire report page to a dashboard?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

I cannot even find the option to just pin a visual any more. Was it removed?

 

I see "Pin Live page" everywhere, but nothing for the visuals.

Hi there

 

Make sure in the report settings that you have not disabled the Visual Options as shown below. This will hide the options to pin the visual

 

image.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

OK, I am feeling a little slow at the moment, but I cannot find this option!

Where is it located? I assume it's in the Service, and not Desktop, right?

OK, I finally found it - in Desktop.

 

I checked and this feature is OFF for all of my reports, so I still don't know why  don't have the option to pin a visual (instead of a whole page).

FOUND IT! There are options on each visual (in Desktop) to also disable the visual header. Corrected this and re-published my reports and now I can pin individual tiles.

 

Thanks!

That is awesome, glad you got it working!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors