Anonymous's avatar
Anonymous
Not applicable
7 years ago
Status:
New

Handling decimal places in numeric slicer

In the current slicer visual when you use the "greater than" or "less than" with decimal numbers there is a problem:
- you set the visual to greater than
-you have numbers in your field with 2 decimal numbers
-the user selects e.g 1.72 as min value
-the min field will show 1.72 but when you click inside it will show 1.72248...
-and the problem is that the your data will be filtered to 1.73 and greater!!!

 

This makes a lot of misunderstanding and confusion.

9 Comments

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous,

     

    Thank you for your detail information. I have consulted this issue internally, will update here once I get information. 

     

    Best Regards,
    Qiuyun Yu 

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi v-qiuyu-msft,

     

    Thanks for looking into this. Do you have any news?

     

    Best regards,

    Ákos

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous,

     

    I didn't get information till now. I already sent a email to require information, will update here once I get any information. 

     

    Best Regards,
    Qiuyun Yu 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous,

     

    I got information that the issue will be fixed in Power BI desktop February release. 

     

    Best Regards,
    Qiuyun Yu 

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi v-qiuyu-msft,

     

    That's wonderful. Thank you very much!

     

    Best Regards,

    Ákos

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi v-qiuyu-msft,

     

    I've just installed the February Release and unfortunately it's not fixed.

     

    Best regards,

    Ákos

  • Hi, 

     

    We really need this functionality too. 

     

    Any updates?

     

    BH

    MoloBI

  • Hi, 

     

    We really need this functionality too. 

     

    Any updates?

     

    BR

    MoloBI

  • PVO3's avatar
    PVO3
    Icon for Impactful Individual rankImpactful Individual

    v-qiuyu-msft 4 years later and it seems like this still isn't fixed. 

    Is there any update?