Multiple measures in one column chart

[uayan]

Hello all, 

When I visualize my 7 measures on bar chart it looks like on the screenshot. How can i show it better? There are a lot of space on the left and right.

Thanks a lot.

[KenSkinner]

@v-jianboli-msft , great solution - but even better was the straight forward explanation and attached PBI file!  Couldn't have been easier and worked perfectly. 

[v-jianboli-msft · Accepted solution]

Hi @uayan ,

Based on your description, I have created a simple sample:

Maybe you can try to add x-axis:

First create a new table for x-axis:

Then create a measure:

Measure = SWITCH(MAX('Table 2'[Value]),
"A1",[A1],
"A2",[A2],
"A3",[A3],
"A4",[A4])

Apply to the visual:

Final output:

Best Regards,

Jianbo Li

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

[SJL007]

Could you please explain what is happening here, step by step ? Why does this solution work?

[lbendlin]

That indeed seems to be a limitation of the standard visual. You can use Deneb to create your own visual, but you should also consider consolidating these measures into one, and to use categories for the X axis instead.