Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
@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)
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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)
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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!
@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
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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,
@russds did you turned off concatenated labels?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
wow you're fast. 🙂
Yes, I did, it's off.
@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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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!
@russds go thru these settings to see if it can get your label space etc, no horizontal option.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Adjusting those settings, did it! Allowing for more space for the text and less space for the bars, this is pretty much it, aside from being horizontal. I wish I could mark all of these as helpful, you've been an amazing help. Any final recommendations if I wanted to pursue horizontal, maybe a custom visual? Thank you,
@russds glad it worked out. I hardly uses custom visuals, not sure if there is something available to achieve what you are looking for. If I come across something I will let you know.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |