Forum Discussion

AmitDarak's avatar
AmitDarak
New Member
1 year ago
Solved

Numeric parameter slicer not working properly

Hi,

 

I have created a Numeric range parameter and using the values of that parameter in slicer.

 

Then I have created a basic measure with switch function. Measure works correctly for 3 values in parameter, but does not work correctly for rest.

It displays correct value when slicer value is 0.7 ,0.75,0.8. But it does not show correct value for 0.85, 0.9, 0.95. By default selects 600. 

 

Not sure of this behavior. Any help would be highly appreciated.

 

 

Regards,

Amit

Need Help
  • miTutorials's avatar
    miTutorials
    1 year ago

    Use the round function for precise matching like below.

     

    Measure = SWITCH(ROUND(Parameter[Parameter Value],2),
                             0.70,  100,
                             0.75,  200,
                             0.80,  300,
                             0.85,  400,
                             0.90,  500,
                             0.95,  600,
                             1000)

3 Replies

  • miTutorials's avatar
    miTutorials
    Super User
    1 year ago

    Use the round function for precise matching like below.

     

    Measure = SWITCH(ROUND(Parameter[Parameter Value],2),
                             0.70,  100,
                             0.75,  200,
                             0.80,  300,
                             0.85,  400,
                             0.90,  500,
                             0.95,  600,
                             1000)
    • AmitDarak's avatar
      AmitDarak
      New Member
      1 year ago

      Hi,

       

      Isn't this strange? It worked correctly for 0.70, 0.75, 0.8 but not working for 0.85, 0.9, 0.95.

       

      Any possible explanation for this logic?

       

      Regards,

      Amit

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi AmitDarak ,
    Thank you for reaching out to the Microsoft fabric community forum. 

     

    Use the below DAX in Modeling--New Table, and enter:

    Tendency1 =

DATATABLE(

    "Tendency Value", DOUBLE,

    {

        {0.7},

        {0.75},

        {0.8},

        {0.85},

        {0.9},

        {0.95}

    }

)

    Use this Measure:

    test_measure =

SWITCH(

    INT(SELECTEDVALUE('Tendency1'[Tendency Value]) * 100),

    70, 50,

    75, 100,

    80, 200,

    85, 400,

    90, 500,

    95, 600

)

     

    To display the result, first add a Slicer visual to the report and drag the 'Tendency'[Tendency Value] column into it. Set the slicer style to Dropdown or Horizontal for better readability. Then, add a Card visual and drag the test_measure into it to show the output based on the selected slicer value.

     

    I am also including .pbix file for your better understanding, please have a look into it:

    Hope this helps. Please reach out for further assistance.

    If this post helps, then please consider to Accept as the solution to help the other members find it more quickly and a kudos would be appreciated.


    Thank you.