bar chart with two measures

[miinseon]

HI all

i want to show two measures in a bar chart.
For example, measure 1 is the number of visitors and measure 2 is the number of paying customers.
If visitors are 1000 and 200 paying customers, i want the range on the y-axis to change with the number of visitors and the number of paying customers to fall within the visitor bar.

See the image below. The graph on the right was created with shapes.

Thanks 🙂

[mark_endicott]

@miinseon - Sorry I realised I placed the bars the wrong way round, in my screenshot it is just a case of swapping the two measures around on the axis. 

As the DAX I have provided has works, please could you mark this as the solution? It makes it easier for people to find, and it will take it out of the "Unresolved topics" bin!

Thanks, 

[mark_endicott · Accepted solution]

@miinseon - You can use a Stacked Column Chart with two measures. See below:

Visitors Paying = SUMX( 'Table (9)', 'Table (9)'[Visitors] - 'Table (9)'[Paying] ) 

and

_Paying = SUM( 'Table (9)'[Paying] ) 

[miinseon]

The value is not what I want.

But I solved it by applying your suggestion

I created and used (visitor - paying).

Thanks 🙂

[mark_endicott]

If this works for you, please accept it as the solution!