Forum Discussion

IF's avatar
IF
Post Prodigy
6 years ago
Solved

Waterfall chart with multiple measures

Hi, I read discussion about waterfall chart but it didn't work when I tried the following. I have product category and 8 measures in the same table. The measures have + and - values. I would like s...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, IF 

     

    Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

     

    Table:

     

    Test:

     

    There is no relationship between two tables: You may create measures as below.

    A Measure = SUM('Table'[A])

R_DM Measure = SUM('Table'[R_DM])

R_Nego Measure = SUM('Table'[R_Nego])

R_Pjt Measure = SUM('Table'[R_Pjt])

Result = 
SWITCH(
    SELECTEDVALUE(Test[MeasureName]),
    "A",[A Measure],
    "R_DM",[R_DM Measure],
    "R_Nego",[R_Nego Measure],
    "R_Pjt",[R_Pjt Measure],
    BLANK()
)

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, IF 

     

    You may go to 'Query Editor', click 'Add Columns'=>'Index Column' to create an index column and then 'Close and Apply'.

     

    Then you need to make the column 'MeasureName' selected, click 'Sort by column'=>'Index'.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, IF 

 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

 

Table:

 

Test:

 

There is no relationship between two tables: You may create measures as below.

A Measure = SUM('Table'[A])

R_DM Measure = SUM('Table'[R_DM])

R_Nego Measure = SUM('Table'[R_Nego])

R_Pjt Measure = SUM('Table'[R_Pjt])

Result = 
SWITCH(
    SELECTEDVALUE(Test[MeasureName]),
    "A",[A Measure],
    "R_DM",[R_DM Measure],
    "R_Nego",[R_Nego Measure],
    "R_Pjt",[R_Pjt Measure],
    BLANK()
)

 

Result:

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • IF's avatar
    IF
    Post Prodigy
    6 years ago

    Hi,

     

    Thanks for the answer. Is there any possibility to display the changes in an order? I would like to sort them "A", "R_DM", "R_Nego", "R_Pjt". I have more to measures. Therefore the order is important for me.

     

    Best,

    • v-alq-msft's avatar
      v-alq-msft
      Community Support
      6 years ago

      Hi, IF 

       

      You may go to 'Query Editor', click 'Add Columns'=>'Index Column' to create an index column and then 'Close and Apply'.

       

      Then you need to make the column 'MeasureName' selected, click 'Sort by column'=>'Index'.

       

      Best Regards

      Allan

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • IF's avatar
        IF
        Post Prodigy
        6 years ago

        Hi,

        I don't know if I am doing something wrong for sorting. As you mentioned,  I add the index column:

        Index columnsorting

        The sorting doesn't change at all. It is a small issue, but annoying me. Maybe I do smtg wrong.

         

        All the best,