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

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

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

    The value is not what I want.

    But I solved it by applying your suggestion

    I created and used (visitor - paying).


    Thanks 🙂