Forum Discussion
Plot zero when there is no data in line chart solution affects the date filter
Hi, Anonymous
Your data is not continuous, and the date column has a specific time.
So you need to create a column and an additional date table,then use that date in slicer.
Like this:
Column = DATE(YEAR([CreatedDate]),MONTH([CreatedDate]),DAY([CreatedDate])) Table = CALENDAR(MIN(testdataPowerBIcsv[CreatedDate]),MAX(testdataPowerBIcsv[CreatedDate]))Here is my sample .pbix file.Hope it helps.
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Anonymous
Your data is not continuous, and the date column has a specific time.
So you need to create a column and an additional date table,then use that date in slicer.
Like this:
Column = DATE(YEAR([CreatedDate]),MONTH([CreatedDate]),DAY([CreatedDate]))
Table = CALENDAR(MIN(testdataPowerBIcsv[CreatedDate]),MAX(testdataPowerBIcsv[CreatedDate]))Here is my sample .pbix file.Hope it helps.
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry for the late reply. There were some prio's changing in work, so I had to postpone the work on this.
When relooking at the issue again, I used the Zoom sliders: https://youtu.be/tZ9F19qTDCI
Not sure if that functionality already existed when the issue started. Really happy with the result. Although your solution is probably much more prettier, this is an fast pragmatic solution. Thank you for your patient in assisting me!