A Card is update after change slicer filter but not refresh into PBI report online

[Anonymous]

I have a Power BI report with multiples pages and multiples Cards in the top, then I let on right side a slicer as filter, all works fine on Power BI Desktop but at time to publish it to online version, it failed on one Card at time to update values, it mean, that four of five Cards are update after change slicer value but the fifth card is not update, at least not on web version, only on Desktop version works fine.

Any idea of why failed?

[Anonymous]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Best regards,
Community Support Team_ Binbin Yu

[Anonymous · Accepted solution]

I'm not sure if the follwoing solve my previous problem, I need double check to confirm the solution but I guess I already soved.

First: The problem started after I added a left join between two dimentions in Model view. This left join added a (Blank) value in the slicer, it is correct because it happen when the the relations is 1 to many and the left table doesn't contain all values tht found in right table.

More details please see following link: https://www.youtube.com/watch?v=23qemkDqMVY

After that I fixed my left table data with append a default value that fix the (Blank) value in the slicer, and look as that fixed the issue.

As I mentioned, I did that just one time, I need redo many times to confirm that was the problem and that solve teh issue.