Forum Discussion
Multiple measures in one column chart
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.
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.
4 Replies
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.
Could you please explain what is happening here, step by step ? Why does this solution work?
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.
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.
