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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
 

 

selimovd
Super User
Super User

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.