Forum Discussion
Dashboards are not refreshing
Hi googlogmob, Are you still see this issue? If so, can you file a support ticket at https://support.powerbi.com/ since may require more in depth troubleshooting. Thanks!
Anonymous As you liked my post I assume your problem is similar to mine (A change in period filters not being reflected in dashbaords).
My solution was to have a hidden page with visualisations specifically made to be used in the dashboards. Instead of using a slicer to update the period for YTD calculations I used a calculated column (named current period) on my period definition date table using the logic is DATE FIELD <= TODAY() to indicate all the dates before or equal today (returning TRUE or FALSE). Then I filtered all my measures for the dashboard by using IS PERIOD <= Max(Period where 'current period' = TRUE and Financial year = 'this year')
Anonymous wrote:My solution was to have a hidden page with visualisations specifically made to be used in the dashboards. Instead of using a slicer to update the period for YTD calculations I used a calculated column...
What do you mean by hidden page?
I am considering to build separate report on the same underlying data, with no slicers or filters, and just prepare measures like "show last 10 days" or something, and then pin visuals based on this measure (perhaps not measure but table/query on underlying data) to dashboard. Is your workarround the same idea?
I think there might be another solution for this: Tableau or QlikView.
For microsoft PowerBI seems not the core business, so they don't give a F about 5 years old issues. I wonder if other BI service suppliers share the same approach.