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 i...
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)
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.