Forum Discussion
Multiple items grouped by month trend
- 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
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