Dashboard report not showing all data

[martinrowe]

I have noticed on several dashboard items that this does not get updated properly when the page that the visual is pinned from has on page slicers.

I have seen this behaviour occur on several visuals and seem to do one of two things, either not update at all with data from the recent dates so it appears "frozen" or partially updates based on no logical set of parameters!

Is this a known issue or expected behaviour, or does this only happen when a report is perhaps too complex or too large? I have tried several approaches but the only one that seems to work is to remove all on page slicers or create a duplcate of the page/visual for a version without the slicers present.

From the screenshots below, the first one is from the dashboard item. The second is of the same visual but opened in the report view. There should be over 100 lines for the date of the 15/01/2018 however the vast majority seem to be truncated in the dashboard view

Thanks

Martin

 

[Ki9890]

I had the same issue and I found that a different visual was drilled down, and this afffected everything else.

[Greg_Deckler]

Could be an issue. However, with Dashboards (not Reports), the issue is often caused because dashboard tiles retain the exact filters and slicer settings at the time of pinning the tile.

[shahid]

@Greg_Deckler You are a life saver! I had RLS filter enabled for x when I pinned tiles to dashboard.I was looking at with RLS filter y and was pulling my hair out why I was not seeing any data on dashboard where reports were working fine.

[Greg_Deckler]

Yeah, that one will drive you insane... 🙂

[martinrowe]

So potentially if I have a date slice on the page, then this could be the cause? I have one that is a between x & y dates which may be the culprit.

The only problem with this though is that it is showing things from the current date, just not all of them and there isnt any obvious thing in common with those that are or are not shown!