Dates are not displaying correctly

[SimonNagy]

Dear All,

I have a very strange error in my report: randomly, on one page, the dates are not displaying, only the first 7 days of the year. As you might see, there are no filters, and I am using only one table as a source. What could've happened? This was working properly a week or so ago. Do you have any ideas?

figure 1 selected:

figure 2

Thank you in advance,

Simon

[SimonNagy · Accepted solution]

Hi @Idrissshatila , @Thennarasu_R ,

thank you for your replies, I've found a hidden rogue date slicer... 😄 Sorry for the stupid question; but for everyone, who is seeing similar things check under View\Selection and see if there are any slicers which are hidden.

[Thennarasu_R]

@SimonNagy 

You have Selected jan month first 10 days but 8,9,10, not showing data in  report level am I right ?

On that data can u check the data is avaliable in data table  ? and U had apply some filters in filter on this page & chek view options also may be hide some filter Chekc this two things.


Thanks,
Thennarasu R

[Idrissshatila]

Hello @SimonNagy ,

I couldn't see any difference between the two screenshots, can you point out what's wrong.

[SimonNagy]

Hi,

on the top, I've selected the top figure, to show figure level filter, and on the bottom, the bottom one. Also, when I'm adding the date filter to the page, then all dates are in the filter (January-01 -> April-15), BUT on the visual level, it's only 7 days.

The visuals should display the whole year, as data is about the whole year in the DWH / schematic model.

Thanks,

Simon

[SimonNagy]

I think, I've found the issue, but cannot find the corresponding filter (display data before 8th of January)