Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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.

Status: New
Comments
v-qiuyu-msft
Community 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
Not applicable

Hi @v-qiuyu-msft,

 

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

 

Best regards,

Ákos

v-qiuyu-msft
Community 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
Community Support

Hi @Anonymous,

 

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

 

Best Regards,
Qiuyun Yu 

Anonymous
Not applicable

Hi @v-qiuyu-msft,

 

That's wonderful. Thank you very much!

 

Best Regards,

Ákos

Anonymous
Not applicable

Hi @v-qiuyu-msft,

 

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

 

Best regards,

Ákos

MoloBI
New Member

Hi, 

 

We really need this functionality too. 

 

Any updates?

 

BH

MoloBI

MoloBI
New Member

Hi, 

 

We really need this functionality too. 

 

Any updates?

 

BR

MoloBI

PVO3
Impactful Individual

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

Is there any update?