Forum Discussion
Group dates by Month
I have a date column with this format MM/DD/YYYY When I make visuals data I get them per day but I would group them by month and from January to December.
For exemple if there is no data on July I would that my visualshows me anyway july on the graphe with 0 data.
5 Replies
hamzahad91 have you got a date table?
For exemple
31/01/2017 00:00 31/01/2017 00:00 31/01/2017 00:00 31/01/2017 00:00 31/01/2017 00:00 31/01/2017 00:00 01/02/2017 00:00 01/02/2017 00:00 01/02/2017 00:00 01/02/2017 00:00 01/02/2017 00:00 01/02/2017 00:00 I Would like to have a table with all year months even if there is no data in a month
you need to create a date table and link that to your data
check out blog post below
https://www.mssqltips.com/sqlservertip/4857/creating-a-date-dimension-table-in-power-bi/
