0 Kudos

Handling decimal places in numeric slicer

Status: New
by AkosSzucs Visitor on ‎01-17-2019 04:48 AM

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.

Comments
by Moderator v-qiuyu-msft
on ‎01-18-2019 02:56 AM

Hi @AkosSzucs,

 

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

 

Best Regards,
Qiuyun Yu 

by AkosSzucs Visitor
on ‎01-29-2019 01:35 AM

Hi @v-qiuyu-msft,

 

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

 

Best regards,

Ákos

by Moderator v-qiuyu-msft
on ‎01-30-2019 12:08 AM

Hi @AkosSzucs,

 

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 

by Moderator v-qiuyu-msft
on ‎01-30-2019 05:38 PM

Hi @AkosSzucs,

 

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

 

Best Regards,
Qiuyun Yu 

by AkosSzucs Visitor
on ‎01-31-2019 12:02 AM

Hi @v-qiuyu-msft,

 

That's wonderful. Thank you very much!

 

Best Regards,

Ákos

by AkosSzucs Visitor
16 hours ago

Hi @v-qiuyu-msft,

 

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

 

Best regards,

Ákos

Idea Statuses