Grouping dates in a bar chart by month

[TBSST]

Hi All, 

I am trying to create a bar chart to show the number of responses by month. The two colums i have is response ID's (y-Axis) and response date (X axis, format dd-mmm-yyyy). 

I am wanting to group the dates together so the bar chart is showing responses in a month, not an indiidual day. The response date data type is set to date/time. 

Any help would be appreciated. 

[Ashish_Mathur · Accepted solution]

Hi,

Seperate time from the Date/Time column.  Create a Calendar Table and then a relationship from the Date column of the Data Table to the Date column of the Calendar Table.  In the Calendar Table, create calculated column formulas for Year, Month name and Month number.  Sort the Month name column by the Month number.  To your visual, drag Year and Month name from the Calendar Table.  Write this measure

Measure = countrows(Data)

Hope this helps.

[Ritaf1983 · Accepted solution]

Hi @TBSST 
If you working with 1 table of fact :
You can add a column with the month:

and put it to X axis

The best Practise to work with dates is to create a date table and "use" it :

Link to a sample file with both options 

For more informations about dates table:

https://www.datacamp.com/tutorial/how-to-create-date-tables-in-power-bi-tutorial

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ashish_Mathur · Accepted solution]

Hi,

Seperate time from the Date/Time column.  Create a Calendar Table and then a relationship from the Date column of the Data Table to the Date column of the Calendar Table.  In the Calendar Table, create calculated column formulas for Year, Month name and Month number.  Sort the Month name column by the Month number.  To your visual, drag Year and Month name from the Calendar Table.  Write this measure

Measure = countrows(Data)

Hope this helps.