Forum Discussion

vbvbvb's avatar
vbvbvb
Microsoft Employee
5 years ago
Solved

Visual + Date Filter + SPO column with Date format - two different results for 2 identical visuals

Hi all,

 

Wondering if can help with this - i have two separate data sources (both SPO lists) with slightly different format of columns and data, but in total they contain fairly similar data. I am trying to make a visual (Line chart) for both of these and whilst 1 of them working just fine: 

Another table with same data used for axis, legend, and values, doesn't want to display values per days:

Only difference I can see here is difference how it filter data. Working Filter groups days using Values:

Non-working count everything as separated 1 values  :

 

Any idea where should I check to make that work like it does in original visual ? 

I suspect that it can be different data format after all - maybe having Date with  Time in non-working table make it different vs pure Date in working?

 

  • It was format of column in the table - since it contained hours and minutes, without transforming data to Date only in Power Query, this wasn't working. I had to transform 100mb+ of SPO data and it started to work just fine.

1 Reply

  • vbvbvb's avatar
    vbvbvb
    Microsoft Employee

    It was format of column in the table - since it contained hours and minutes, without transforming data to Date only in Power Query, this wasn't working. I had to transform 100mb+ of SPO data and it started to work just fine.