Creating a bar graph

[paris]

Hi All,

Need your help again! 

I want to create a bar graph by country by product by month. However my data source is not on monthly basis or daily basis but date of sales basis so it makes difficult... 

Appreciate your help.

All the best,

Love Paris

[Ashish_Mathur · Accepted solution]

Hi,

Build a relationship from the Shipping Date column of the Sales Table to the Date column of the Calendar Table.  In the Calendar Table, extract Year and Month by using the calculated column formulas

Year = Year(Calendar[Date])

Month = FORMAT(Calendar[Date],"mmmm")

To your visual, drag Year and Month from the Calendar Table.  Write this measure

Total Sales = SUM(Data[Sales])

Hope this helps.

[paris]

Ashih,

Thank you very much for your help!

All the best,

LoveParis

[Ashish_Mathur]

You are welcome.