Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
jkneazle
Frequent Visitor

Is it possible to build a bar chart with different measures and color legend?

‎05-10-2024 11:34 AM

I'm trying to convert a Tableau dashboard into Power BI and ran into this visual. It appears as a clustered bar chart with 6 different measures, each measure is a row, and the legend being another category. 

 

Those "Flag" calculations were built like so:

Interview Flag

if ISNULL([Interview Date]) then 0 else 1 END

 

Columns are all the percentages by row; rows are the sumof the flags; legend is Location Type. 

TableauTest1.jpg

 

Is there anyway to replicate this in Power BI? 

Labels:
Message 1 of 3
118 Views
0
2 REPLIES 2
Ritaf1983
Super User
Super User

‎05-10-2024 11:52 AM

Hi @jkneazle 

The graph is possible to create. It might require an auxiliary table of metric names with all the combinations of the three categories and using a dynamic measure with selectedvalue ().
The guide to working with the method :

https://www.youtube.com/watch?v=ODNsd1G4tDM&t=1323s

Or maybe this is possible with Unpivoting the data table .

To provide further assistance and demonstrate the process, please provide a sample dataset that can be worked with. It doesn't have to be real data. You can generate a sample dataset with the required logic. Refer to this link for guidance on how to do this:

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

 

 

Message 2 of 3
98 Views
0
jkneazle
Frequent Visitor
In response to Ritaf1983

‎05-13-2024 10:52 AM

Hi there! Thank you for responding to my post.

What I'm trying to achieve is to show all 6 measures in its own bar stacked next to each other, as well as the percentages, with legend being the Location Type. The YouTube video, however, shows a visual that interacts with a buttom. Is it possible to show all these without a button?

 

I'm pasting test data below: 

Candidate IDApplied DateReviewed DateScreened DateHiring Manager Reviewed DateInterview DateHire DateLocation Type
5748911/15/20241/16/20241/16/20241/16/20241/24/20243/18/2024Office
2097361/9/20241/10/20241/16/20241/19/20241/22/20242/12/2024Hybrid
8456201/27/20241/29/20241/29/20241/29/20241/29/20243/11/2024Remote
3621542/23/20242/23/20242/26/2024   Remote
9873452/19/20242/20/20242/21/20242/21/20242/23/20244/1/2024Remote
6318971/11/20241/12/20241/25/20241/28/20241/29/2024 Remote
7402582/19/20242/19/20242/19/20242/21/20242/22/20244/22/2024Remote
5184631/9/20241/9/20241/9/20241/9/20241/16/20244/15/2024Remote
1238091/8/20241/8/20241/8/20241/8/20241/8/20241/29/2024Office
6954322/15/20242/15/20242/15/20242/15/20242/15/20243/4/2024Hybrid
8246132/6/20242/7/20242/15/20242/15/20242/16/20243/11/2024Office
3579822/26/20242/27/20242/27/20242/27/20242/27/20243/25/2024Hybrid
5690211/12/20241/16/20241/16/20241/18/20241/22/20242/26/2024Office
7108461/7/20243/18/20243/20/20243/20/2024  Hybrid
2365471/15/20241/25/20241/25/20243/8/2024  Office
9813643/11/20243/11/20243/13/20243/13/20243/21/2024 Office
4032891/21/2024     Hybrid
6157203/1/20243/1/20243/1/20243/5/20243/5/20244/22/2024Hybrid
1784933/13/20243/13/20243/14/20243/14/20243/14/2024 Remote
9520381/22/20241/23/2024    Remote
Message 3 of 3
28 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

View All