The problem is that dashboard tiles are not refreshing, whereas the report connected to the dashboard is updating properly according to the set schedule. This problem became very frequent about a week ago, at the same time as the Shapes option was added. Since that only manual update helps (I simply repin the tiles to the dashboard). As I pin a fresh tile to the dashboard, the similar tile pinned earlier also gets updated. But after manual repining of the tile, it is not getting updated anymore, unless I repin it again. Please, advice how the dashboards could be updated regularly and automatically (without my participation).
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.