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

     

     

     

4 Replies

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

     

     

     

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

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