Forum Discussion

miinseon's avatar
miinseon
Icon for Helper I rankHelper I
2 years ago
Solved

bar chart with two measures

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...
  • mark_endicott's avatar
    mark_endicott
    2 years ago

    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] )

     

     

     

mark_endicott's avatar
mark_endicott
Icon for Super User rankSuper User
2 years ago

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,