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

[Anonymous]

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. 

Is there anyway to replicate this in Power BI? 

[Ritaf1983]

Hi @Anonymous 

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-Forum/ba-p/963216

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

[Anonymous]

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 ID	Applied Date	Reviewed Date	Screened Date	Hiring Manager Reviewed Date	Interview Date	Hire Date	Location Type
574891	1/15/2024	1/16/2024	1/16/2024	1/16/2024	1/24/2024	3/18/2024	Office
209736	1/9/2024	1/10/2024	1/16/2024	1/19/2024	1/22/2024	2/12/2024	Hybrid
845620	1/27/2024	1/29/2024	1/29/2024	1/29/2024	1/29/2024	3/11/2024	Remote
362154	2/23/2024	2/23/2024	2/26/2024				Remote
987345	2/19/2024	2/20/2024	2/21/2024	2/21/2024	2/23/2024	4/1/2024	Remote
631897	1/11/2024	1/12/2024	1/25/2024	1/28/2024	1/29/2024		Remote
740258	2/19/2024	2/19/2024	2/19/2024	2/21/2024	2/22/2024	4/22/2024	Remote
518463	1/9/2024	1/9/2024	1/9/2024	1/9/2024	1/16/2024	4/15/2024	Remote
123809	1/8/2024	1/8/2024	1/8/2024	1/8/2024	1/8/2024	1/29/2024	Office
695432	2/15/2024	2/15/2024	2/15/2024	2/15/2024	2/15/2024	3/4/2024	Hybrid
824613	2/6/2024	2/7/2024	2/15/2024	2/15/2024	2/16/2024	3/11/2024	Office
357982	2/26/2024	2/27/2024	2/27/2024	2/27/2024	2/27/2024	3/25/2024	Hybrid
569021	1/12/2024	1/16/2024	1/16/2024	1/18/2024	1/22/2024	2/26/2024	Office
710846	1/7/2024	3/18/2024	3/20/2024	3/20/2024			Hybrid
236547	1/15/2024	1/25/2024	1/25/2024	3/8/2024			Office
981364	3/11/2024	3/11/2024	3/13/2024	3/13/2024	3/21/2024		Office
403289	1/21/2024						Hybrid
615720	3/1/2024	3/1/2024	3/1/2024	3/5/2024	3/5/2024	4/22/2024	Hybrid
178493	3/13/2024	3/13/2024	3/14/2024	3/14/2024	3/14/2024		Remote
952038	1/22/2024	1/23/2024					Remote