Forum Discussion

menphis21's avatar
menphis21
Icon for Helper IV rankHelper IV
4 years ago

Simple Waterfall, how i can use a measure with a switch function to make a button

Hello Everyone,

 

I have a table with a variable, value and also percents values.

I would like to create a button that can change the values of my graph simple waterfall. But it seemes that he is not able to accept measure.

Someone has a way to bypass this ?

 

thank you 🙂

 

My dax measure :

 

_Select Metric Capital Surplus = SWITCH(
true(),
"Percent" in ALLSELECTED('Metrics Capital Surplus'[Column1]), [_Sum Percent Capital Surplus],
"Values" in ALLSELECTED('Metrics Capital Surplus'[Column1]), [_Sum Value Capital Surplus] )

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi menphis21 ,

     

    I think you can create a slicer and show dynamic results by a measure.

    Measure Type = 
{"Percent","Values"}

    Measure:

    Measure = 
VAR _SELECTION = SELECTEDVALUE('Measure Type'[Type])
RETURN
SWITCH(_SELECTION,
"Percent",[_Sum Percent Capital Surplus],
"Values",[_Sum Value Capital Surplus])

    Result is as below

    This way could show values in only one data type. If you want show values in number type and percent in %. I suggest you to try calculation group in Tabular Editor .

    For reference:

    Data Labels! Formatting 100.00% as 100%

     

    Best Regards,
    Rico Zhou

     

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

     

     

    • menphis21's avatar
      menphis21
      Icon for Helper IV rankHelper IV
      4 years ago

      Hi

       

      Thank your for your response.

       

      First of all, i had to to create a data table by "Enter Data" because hi didnt accept me the measure in the selectedvalue function.

       

      Also, it didnt want to accept me the measure in the waterfall chart. ( I use the simple waterfall plugin but i tried also with the native one and it doesnt work.) 

      I put a screenshot to show you.

       

      Thank you for your help

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi menphis21 ,

         

        I think your issue should be caused by your data model. Can you share a sample file without sensitive data with me? And show me a screenshot with the result you want. This will make it easier for me to find the solution.

         

        Best Regards,
        Rico Zhou

         

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

  • menphis21's avatar
    menphis21
    Icon for Helper IV rankHelper IV
    4 years ago

    Hi Anonymous ,

     

    Did you find a way to solve this issue ?

     

    Thank you

  • menphis21's avatar
    menphis21
    Icon for Helper IV rankHelper IV
    4 years ago

    HI Anonymous , did you have the time to check ?

    Thank you for your time