Forum Discussion
Date
Yes, it's recommended to use a calendar table for that and you should start with a basic one and grow with the needs. Keeping the model cleaner is always important!
If you allow me i can also recommend to use the tool Bravo from SQLBI to create the date table. It's simple and it allows some customization to start.
If you want you can also use a calendar created in Power Query, there are some good example in the web.
Tell me if you need any more help!
Regards,
Sérgio Silva
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
No problem. That's easy, in the visual in the date value that you will use for example in the x-axis, you can see there is a down arrow. Click there and select an option that says something like Show items with no data.
Let me know if you need further help.
SergioSilvaPT That did show all of the dates, but it starts when my calendar table date starts, not the dates that my data is supposed to be showing. Any suggestions?
villasenorbritt did you check the this option? (Show items with no data)
It shouldn't be enabled.
If this didn't help can you post the PBIX file so i can check?