cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
nirrobi Member
Member

Dashboard not update after changing filter in power bi desktop

Hi all,

 

I have power-bi desktop file that update dasgboard in the power-bi app.

All work smoothly

but...

when I change the filter in the power bi desktop (i.e change month/year/etc)

the change is not reflecting the dashboard and I need to re-pin the tile to the dashboard for the change to be reflected in the dashboard.

 

this is very annoying!

 

Is there any other solution to the problem.

 

Many thank.

 

Nir

1 ACCEPTED SOLUTION

Accepted Solutions
greggyb New Contributor
New Contributor

Re: Dashboard not update after changing filter in power bi desktop

Power Query has some great functions for handling dates. Add two fields to your date dimension:

 

// Power Query

CurrentMonthFlag =
Date.IsInCurrentMonth( [Date] )


YTDFlag =
Date.IsInYearToDate( [Date] )

These will be true or false, depending on where the date on that row falls. You can then filter your reports on CurrentMonthFlag = True and / or YTDFlag = True.

When your model refreshes overnight, these fields will be updated. Your filters need not change, because the underlying data has changed for you.
7 REPLIES 7
Super User
Super User

Re: Dashboard not update after changing filter in power bi desktop

No fix, that is "By design". Dashboard tiles retain the filter context at the time of pinning.

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

Proud to be a Datanaut!


nirrobi Member
Member

Re: Dashboard not update after changing filter in power bi desktop

thanks for your prompt reply! 

 

is there any workaround to solve the issue?

is not normal every month to re-pin all tile (for my opinion..)

Super User
Super User

Re: Dashboard not update after changing filter in power bi desktop

Depends on the specific case, you might try having a calculated column called Current Month = MONTH(TODAY()) and use that as your filter, something along those lines.

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

Proud to be a Datanaut!


nirrobi Member
Member

Re: Dashboard not update after changing filter in power bi desktop

thanks a lot.

maybe you can hekp me,

I have wonderful (:-)) report and dashboard that show data to our top managment,

every month we update the filter in the report to reflect current month and YTD - the filter depand on date of sale.

 

can I solve it smarter?

 

Many thanks!

 

I dont live in Ohio :-)

greggyb New Contributor
New Contributor

Re: Dashboard not update after changing filter in power bi desktop

Power Query has some great functions for handling dates. Add two fields to your date dimension:

 

// Power Query

CurrentMonthFlag =
Date.IsInCurrentMonth( [Date] )


YTDFlag =
Date.IsInYearToDate( [Date] )

These will be true or false, depending on where the date on that row falls. You can then filter your reports on CurrentMonthFlag = True and / or YTDFlag = True.

When your model refreshes overnight, these fields will be updated. Your filters need not change, because the underlying data has changed for you.
nirrobi Member
Member

Re: Dashboard not update after changing filter in power bi desktop

 

W O W !

Its look great and I was able to implement it via - edit query in power bi desktop.

I will wait to next mont (5 days) to verity it work properly.

 

thank you a lot!!!!

 

Nir.

EddyJawed Frequent Visitor
Frequent Visitor

Re: Dashboard not update after changing filter in power bi desktop

Greg, That's a genius trick nice one