How to combine multiple measures in single bar chart with uniform axis

[dkernen2]

I need to create a chart that has a categorical value on the Y axis and two separate measures on the X axis.  This is very straightforward in Tableau.  In PBI, I can do this by creating two separate bar charts, but that creates difficulties if my business users sort one of the two charts, as the other will then have a different sort.  Also, if I only want to show the category on the leftmost chart, then the size of the right has to be different, and sizing it is very kludgy.

In the Tableau example below, I have identified the category Status with red arrows, metric 1 Count with green, and metric 2 Amt with blue.

Can you please tell me how to do this in PBI?  Do I need a custom visual?  If so, what custom visual would work?  Thank you so much!

I created a tiny test file that has one category and two metrics.  https://kauffman.box.com/s/h2c7jest3kpxz7xmvvv4ic009q2kkxjc

[Dhairya]

Hey @dkernen2 
You can achieve this using the field parameter, Please follow the below steps 
Step 1: Create two measures

Total Count = SUM('Table'[Count])

Total Amount = SUM('Table'[Amount])

Step 2: Create a Field Parameter

Add the above created two measures in your field parameter. Slicer will be added to your page

Step 3: now create a bar chart and put your  parameter in the x-axis

Now when you select any value on the slicer which you want to display on the bar chart, This way you will be able to use two measures in one bar chart.

If this helps you then please mark my solution as accepted so that others can find it quickly when they face a similar issue. Thank you!

[dkernen2]

Thank you @Dhairya  for your speedy reply!  My requirement is to show both measures in the dashboard at the same time.  It appears that the field parameters allows me to select from a list of measures and show just one at a time.  Can you show me how to show multiple measures at the same time?

[Dhairya · Accepted solution]

Hey @dkernen2 
It was my bad I interpreted it incorrectly
To show a bar chart side by side there is no default visual available in Power BI but there is a custom visual named "Side by Side Bar Chart(Standard)" from PBIVizEdit.com

Here in this visual, you can plot multiple measures side by side, below is the expected output

If this helps you then please mark my solution as accepted so that others can find it quickly when they face a similar issue. Thank you!

[dkernen2]

Yes!  That's it!  Thank you so much.  Unfortunately, I am not quite ready yet at my organization to purchase custom visuals, but I am glad to know this is available.  Thank you!