Forum Discussion

Ramendra's avatar
Ramendra
Helper IV
4 years ago
Solved

Multiple items grouped by month trend

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's avatar
    4 years ago

    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