Multiple items grouped by month trend

[Ramendra]

Dear Team,

Can someone please help me to know that how to achieve below type of chart grouped in to months by item in Power BI.

[Pragati11 · Accepted solution]

Hi @Ramendra ,

You can easily achieve the above chart in Power BI.

First thing you need to do is extract Month-Year from your date, so that you can have it as a Legend. You can folow this easy article on how to get Month-Year from Date column in Power BI: 

https://radacad.com/generate-year-and-month-combinations-in-power-bi-report-using-dax

Once you have this column, create a Clustered colum chart visual:

Then move your respective fields. I created one chart at my end as follows:

• You can replace product Line from above chart with your ITEM column
• Legend will have your Month-Year column that you create following the link I shared above.
• Value section will have the metric you want to display. I have Quantity in this chart.

Hope this helps.

Thanks,

Pragati

[Ramendra]

@Pragati11 , thanks for quick help.