Forum Discussion
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
- vbvbvbMicrosoft 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.