Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Nikhil_567
Helper II
Helper II

Legends in clustured column chart

Hello Champs,

How can I create a clustured column chart like below?

Two bars are created for Current Month and Previous Month.
The challenge I am facing in introducing the legends which is status column from the dataset, it's not allowing me to drag and drop the column in the legend section.

 

Nikhil_567_1-1735030200588.png

 

Please help.

1 ACCEPTED SOLUTION
Tahreem24
Super User
Super User

@Nikhil_567 Moreover, I found some custom visuals from AppSource. Download and try it. 

Tahreem24_1-1735031020750.png

 



Tahreem24_0-1735030826506.png



Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

View solution in original post

5 REPLIES 5
v-junyant-msft
Community Support
Community Support

Hi @Nikhil_567 ,

Agree with @Tahreem24 , 
and @Nikhil_567 , If you think your idea is meaningful, I suggest you post it here and give it a thumbs up. Maybe your idea can be realized in the future.

https://ideas.fabric.microsoft.com/ 

Best Regards,
Dino Tao

Tahreem24
Super User
Super User

@Nikhil_567 Moreover, I found some custom visuals from AppSource. Download and try it. 

Tahreem24_1-1735031020750.png

 



Tahreem24_0-1735030826506.png



Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
Nikhil_567
Helper II
Helper II

@Tahreem24 Any alternative you can suggest to add the legends here?

@Nikhil_567 There is no feature to add legend with multiple values. You could try some mentioned custom visuals else split the chart into two different visuals.

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
Tahreem24
Super User
Super User

@Nikhil_567 Seems like you want to combine Clustered Column chart with stacked chart but sadly no direct native visual is available for this requirement.

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.