Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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:
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:
Hope this helps.
Thanks,
Pragati
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
60 | |
51 |
User | Count |
---|---|
164 | |
84 | |
68 | |
68 | |
58 |