Column Chart with values from different measures

Power BI
1

Hi,

I want to create a column chart like the one I’m showing, but the values come from two differente measues and I’m not able to create a correct legend neither the correct X axis labels.
I thought in using the Line and Clustered column chart but I do not want representing the second value as a line, but as a column.
It is this possible?
Do you have any suggestion that could help me achieve this visual layout?

image

2

@JoaoMonteiro For me the easiest method would be to achieve the required visual with the help of Calculation Groups. To create CG, you should go to Tabular Editor & on Tables, right click and select create calculation groups & rename that CG.

1
11334×817 103 KB
2
21329×810 153 KB

Then right click on the renamed CG and select create Calculation Items. I renamed the first calculation Item as Measure 1 & the second one as Measure 2:

3
31329×838 146 KB
4
41331×714 126 KB

Then save your changes in Tabular Editor & refresh the page in PBI desktop:

5
51324×656 129 KB

Then you can bring the category/date on X-Axis, the newly created calculation group in legend and measure in Values:

6
61385×702 54.7 KB

Now you are good to go. I hope this solves your problem.

Thanks,
Mudassir

Column Chart with values from different measures.pbix (123.9 KB)

2 Likes
3

Hi @MudassirAli

Thank you so much for your help.

Regards
Joao Monteiro

1 Like