creating bar chart with legend as y-axis

[Anonymous]

Hi Team,

I am doing a Tableau to PowerBI migration and come across a visual that needs to be achieved. Can you please help me out if it's possible to do the same in PowerBI or using some extension?

Not able to add the second column Volume (kg) and VM in power bi as it comes as a legend.

Expected output from Tableau

Current output in PowerBI

@Anonymous @parry2k  @amitchandak @Ritaf1983 @lbendlin 

[vicky_ · Accepted solution]

Use the matrix visual, and use cell formatting to achieve that

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
You can achieve it with hierarchies/matrix and conditional formatting (but both bars will be with the same color).

i attached a pbix you can follow my steps

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

[vicky_ · Accepted solution]

Use the matrix visual, and use cell formatting to achieve that

[Anonymous]

Hi @vicky_ , I used Matrix Visual for the same but the only limitation it is having currently is if there is a negative value then both axis start points is getting different.

[vicky_]

I hope I'm understanding your issue properly - but if you want the bars to always point to the right, then you can use the ABS() function to get the absolute (positive) value. So instead of using BL directly, create a measure like BS2 = ABS(SUM([BL])) and use that in your visual instead.