Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
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..)
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 🙂
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.
Greg, That's a genius trick nice one
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.
User | Count |
---|---|
94 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |