cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
russds Frequent Visitor
Frequent Visitor

Creating a Bar Graph with nested groups

I'm trying to recreate a tableau visual using power bi, but not finding an equavalant.  Does anyone know how I might recreate the below visual bar graph?  It's showing the labels for the bar graphs grouped.  It's a ticketing system, so it's showing the ticket assigned to, and their tickets, amount of time budgeted and spent. I've tried various bar graphs in power bi and the marketplace but haven't found something like this yet. Thanks! 

 

2019-05-25_9-26-16.jpg

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Creating a Bar Graph with nested groups

@russds there are few ways to do, you can use matrix visual and put both the table columns on rows and whatever value you want to show, put that measure on value. Next to value measure, in conditional formatting choose bar graph.

 

here is more detail on data bars (conditional formatting)






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





11 REPLIES 11
Super User
Super User

Re: Creating a Bar Graph with nested groups

@russds there are few ways to do, you can use matrix visual and put both the table columns on rows and whatever value you want to show, put that measure on value. Next to value measure, in conditional formatting choose bar graph.

 

here is more detail on data bars (conditional formatting)






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





russds Frequent Visitor
Frequent Visitor

Re: Creating a Bar Graph with nested groups

This is great, thank you.  It's so close, and does give the breakdown i was looking for.  I'm also looking to combine a bar value with a benchmark, like the below screen shot.  Any idea how I can put another value along side the original value as a benchmark, ie the red lines? 

 

Thanks!

 

2019-05-25_23-02-50.jpg

Super User
Super User

Re: Creating a Bar Graph with nested groups

@russds I don;t think you can add those red lines Other option you have is to use Line and Clustered Column chart 

 

You can assign and task to on x-axis and drill down to task, in format pane, turn off Concatenate Labels

 

And now you can use benchmark value on line, turn on marker and change stroke width to 0, you will get something like this

 

image.png






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





russds Frequent Visitor
Frequent Visitor

Re: Creating a Bar Graph with nested groups

Thank you @parry2k , I was able to get a bar, and this looks great, except when i drill down 1) it's vertical which isn't pleasing for a long list like this, and 2) the tasks aren't grouped under a name, they appear as one long horizontal list. 

 

Not sure if there's anything else to try. Thank you, 

 

 2019-05-26_7-27-22.jpg

Super User
Super User

Re: Creating a Bar Graph with nested groups

@russds did you turned off concatenated labels?

 

image.png






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





russds Frequent Visitor
Frequent Visitor

Re: Creating a Bar Graph with nested groups

wow you're fast. Smiley Happy

Yes, I did, it's off. 

 

2019-05-26_7-40-33.jpg

Super User
Super User

Re: Creating a Bar Graph with nested groups

@russds do one thing? Click on dots on top right corner and choose different column under sort by and check if bar graph changes, you can change back sort by once it works.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





russds Frequent Visitor
Frequent Visitor

Re: Creating a Bar Graph with nested groups

So close, now tasks are grouped by their assigned person. The tasks have long names and have ... at the end, anyway to shrink the size of the bars and increase the size of the labels? or anyway to flip the whole thing horizontally? 

Thank you! 

 

2019-05-26_7-50-05.jpg

Highlighted
Super User
Super User

Re: Creating a Bar Graph with nested groups

@russds go thru these settings to see if it can get your label space etc, no horizontal option.

 

image.png






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 6 members 3,659 guests
Please welcome our newest community members: