Multiple measures on independent x axis with shared y axis

[Anonymous]

I can't find a way to show my three measures in a bar chart. I want the y axis to be shared using one dimension and 3 independent x axes for each of the three measures. In this way I don't have to duplicate (and use up space) to show the same y axis over and over. It should allow for independent sorting on each measure. This is extremely easy to do in Tableau and I'm struggling trying to figure out how to do it in Power BI. Please help.

[Anonymous]

Hi,

I Have one requirement in which I need to show one measure with less than 0 value and one measure with greater than 0 value in the same Y-axis.

The values should be shown as left side negative and right side positive values of the Y-axis in bar chart.

Can anyone help me with this ?

[v-yuta-msft]

@Anonymous,

Put your X-axis column into X-axis field, put three measures into Value field.

 

If still can't meet your requirement, please provide more details or sample data.

Regards,

Jimmy Tao

[Anonymous]

I tried that but it stacks them. I want them to be on an independent axis. I would add an image but this form doesn't allow me to.

[v-yuta-msft]

@Anonymous,

I'm afraid the built-in visuals may not meet your requirement, I would suggest you to try custom 3D visual SandDance and check if it can meet your requirement.

Regards,

Jimmy Tao

[Anonymous · Accepted solution]

I was able to solve for this by using a Matrix table and showing the data bars.