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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

0

Slicer (between slicer) is allowing decimal range instead of whole numbers

I created a table with 2 columns (value,label), 1 to 20, A to T.  The value is whole number.  I create a Table tile with both columns and insert a slicer with the Value column.  

 

Z_AllData.JPG

 

 

 

 

 

 

 

 

 

 

 

Now I drag the right slider to value 8 and then drag the left slider to the furtherst right it can go, which is also 8.   The filtered table does not return any data but should be showing (H,8).

Z_FilteredData.JPG

 

 

 

 

 

 

 

 

 

 

 

The reason it is not returning data is because when i moved the right slider it was set to 8.434275236 even though it showed 8.  When i slide the left slider to match the 8 it also was set to 8.434275236.  The slicer allows a person to move the slider to a decimal number even when the data type is whole number.    The result is correct because 8 is less than the selected decimal numbers but when you are moving the slider you do not see the decimal places.

 

You can only see the decimals when you click in the value field.

 

Z_DecimalData.JPG

 

 

 

 

 

 

 

 

 

 

 

 

This needs to be fixed to only let the slider select whole numbers when the data type is whole numbers.

 

Status: Delivered
Comments
v-qiuyu-msft
Community Support

Hi @jinkaid,

 

I have sent a email to consult this issue internally, will update here once I get any information.

 

q2.PNG

 

To work around the issue, please type 8 in boxes to filter values.

 

Best Regards,
QiuyunYu

v-qiuyu-msft
Community Support

Hi @jinkaid,

 

I got below response from PG team:

 

Yes this is a known thing. We have a defect for tracking this but right now it is pretty much by design. We format the display in input boxes using formatting set on the column but the actual filter applied is not formatted. If you click in the text box, it shows the actual value used in the filter.

 

Best Regards,
QiuyunYu

Vicky_Song
Impactful Individual
Status changed to: Delivered