cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sanchit_1610
Helper I
Helper I

Clustered Bar Graph Multi Value with Legends

Hi Team,

 

Greetings!!!

 

I am looking to build a multi valued clustered bar graphs, but in current scenario it is not allowing to have the legend or custom legend.

 

Below is screenshot of what i want to achieve

 

sanchit_1610_0-1623004598878.png

There are 3 sectors i.e. L1, L2 & L3 for which quantity is calculated across Category A1 and A2 over a period of time.

 

Please advise.

 

Thanks

Sanchit

1 ACCEPTED SOLUTION

Hey @sanchit_1610 ,

 

the closest I would do is the following:

selimovd_0-1623167220120.png

 

Would that work?

You can find my solution here:

https://www.swisstransfer.com/d/72d76802-4227-4627-93bb-aac2d0bec490

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

 

View solution in original post

5 REPLIES 5
sanchit_1610
Helper I
Helper I

Hi @selimovd 

 

Thanks for your reply,

 

I am still not able to achieve the graph as in this case i will need to create a hierarchy and on hiding how do i show only months.

 

Thanks

Sanchit

Hey @sanchit_1610 ,

 

why you can't create the graph like this?

Where are you struggling? Which parts don't work as expected?

 

Best regards

Denis

Hi @selimovd ,

 

Please find sample pbix uploaded using below link, can you please help me achieve the ask

 

https://easyupload.io/bsl6xw

 

password -12345

 

Thanks

Sanchit

Hey @sanchit_1610 ,

 

the closest I would do is the following:

selimovd_0-1623167220120.png

 

Would that work?

You can find my solution here:

https://www.swisstransfer.com/d/72d76802-4227-4627-93bb-aac2d0bec490

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

 

View solution in original post

selimovd
Community Champion
Community Champion

Hey @sanchit_1610 ,

 

use a stacked column chart, don't show the Y-Axis and put the sectors in the legend:

selimovd_0-1623004844002.png

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors