Dashboard KPI tiles not updating

[Anonymous]

I have Googled this issue, but I couldnt find any 2019 or newer threads with a concrete answer to my issue. I have multiple reports published, refreshing on a daily schedule. Every one of these reports has a KPI tile that I've put on a dashboard to combine. I intend to publish this dashboard every Monday, but currently the tiles (even after using the refresh button in the ...-dropdown) just dont update based on the new filter I'm giving it. The tile is week 8, but clicking on it brings me to the report that I already filtered to week 9. I have not republished the report, I just changed the filters on the published page so I shouldnt need to recreate the tile.

What am I doing wrong? 

[Anonymous · Accepted solution]

Just to update in case others were looking for the same solution, using the formula below for the KPI tiles that needed it fixed my dashboard issue:

NAME = CALCULATE(SUM("SUM COLUMN"),FILTER(ALL("WEEK COLUMN","YEAR COLUMN","WEEK COLUMN" = WEEKNUM(today())-1&&"YEAR COLUMN" = YEAR(today())))

[V-lianl-msft]

Hi @Anonymous ,

If the original visualization that's used to create the tile changes, the tile doesn't change. For example, if you pin a line chart from a report and then you change the line chart to a bar chart, the dashboard tile continues to show a line chart. The data refreshes, but the visualization type doesn't.

I would suggest you to vote the idea.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tad17]

Hey @Anonymous 

Check out this thread: https://community.powerbi.com/t5/Service/Dashboard-tiles-are-not-updating/td-p/424486

Here is the link about Tile refresh in that thread: https://docs.microsoft.com/en-us/power-bi/service-dashboard-tiles

Your situation is interesting. Changing a filter counts as changing the visual. It is updating, meaning the new data is "in" the tile, but it will not update with your filter on the report. This is actually a good thing so that the dashboard doesn't change everytime someone is "playing" with the report. To get around this I would suggest using a measure to calculate the most recent week. That way you don't have to update the visual each week. Just refresh the dataset.

If this helps please kudo.

If this solves your problem please accept it as a possible solution.

[Anonymous]

The filter is definitely causing the issue, because it does indeed update if I select the current week; current week goes up in numbers on a daily basis, instead of reporting on the previous week thats already done.

Preferably I'd like to have a dashboard that links to both weekly and YTD, but with the option to have users select older weeks. However, the workaround (what youre suggesting as well) to have a column-output for "current week -1" to apply just to the KPI tile would solve the issue. I was hoping for a more efficient solution, but I guess it makes sense in a way. Would be nice to have the option though, I'm sure I'm not the only one that prefers to have tiles to just reflect whatever the report is showing on refresh.