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
Kmcdonald
Helper III
Helper III

Bar Graph - 2 Different Categories

Hi,

I'm trying to replicate the below report, from Excel into BI so that I can have it refresh instead of manually adding data.

Kmcdonald_0-1646268368683.png

 

This is what I have been able to do so far (not quite what I'm trying to achieve):

Kmcdonald_4-1646268787981.png

 

 

 

Kmcdonald_3-1646268764714.png

 


The first screen shot from BI, is good but I need to seperate another category which is a status of open and closed. Since I have 4 categories per month (observation ,minor, major, and ciritical), I'd like these to be shown all in one bar but have the 2nd category of open/closed, showing two bars each month.

I can't find anywhere to put the second category on the first screen shot (putting the status into the "Shared Axis" area doesn't do anything) and I don't like the small multiples on the second screenshot.

Can anyone help me replicate 

1 ACCEPTED SOLUTION

@Kmcdonald , the First option is to concatenate label off. Expand axis, sort on that concatenate label off

Concatenate Label off : https://youtu.be/QgI0vIGIOOk

 

Or you use small multiple for open and close https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-small-multiples

 

 

View solution in original post

6 REPLIES 6
Mayank_Yavda
Resolver II
Resolver II

Hi @Kmcdonald ,

 

Here, is a 100 % Stacked Clustered Column Chart where you can put two different values (e.g: Open and Close) and also add category on legend for the stacks. You can change 100% to only stacked columns by selecting - under visual attributes > Bar Chart > All > From (None, Percent, Fraction) select None. Hope this helps you.

 

100 % Stacked Clustered Column Chart. pbivizedit.com100 % Stacked Clustered Column Chart. pbivizedit.com

 

 

 

 

 

 

 

 

 

Download link for the custom visual file on this page,

https://pbivizedit.com/gallery/100stacked-clustered-column-chart 

 

This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,

  • anyone, irrespective of technical skills, can create their visuals
  • 15 minutes to create a visual from scratch
  • opens up many additional attributes to edit (e.g. labels, tooltips, legends position, etc)

Give this a shot and let us know if you face any problems/errors.
You can use the editor to modify your visual further (some modifications cannot be done in the Power BI window and have to be in the editor).

 

Thanks,
Team PBIVizEdit

mussaenda
Super User
Super User

If I understood you correctly,

You want to compare the Open and Close with the same x axis on the same graph.

 

With this,

You can put the Open Close Category on the axis and play with the heirarchy until you achieve what you need.

 

Hope this helps.

 

Thanks

Kmcdonald
Helper III
Helper III

Don't need the total, just seperated out as open and closed. If I need the total I can do so with a different visual.

@Kmcdonald , the First option is to concatenate label off. Expand axis, sort on that concatenate label off

Concatenate Label off : https://youtu.be/QgI0vIGIOOk

 

Or you use small multiple for open and close https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-small-multiples

 

 

Thank you, that was bugging me for the last week 😅

VijayP
Super User
Super User

@Kmcdonald 

Bit confusing ! Do you want keep the open close as a total ? because the excel snapshot is showing so! can you draw some picture to show what is final out come or confirm that Excel one where both open close are together

 




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


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.