Forum Discussion

liselotte's avatar
liselotte
Advocate I
1 year ago
Solved

Formatting decimal separator

I live in Europe and the format of decimals should be ###.###.##0,00. I set up the region as German(Germany). When I use the custom format of ###,###,##0.00, it still shows the decimals as ###.###.##0,00 in visual, which is nice.

But I have a slicer of parameter in format of percentage. When I enter, for example, 50% or 0,5, it doesn't recognize them as 50%. Instead, I have to enter 0.5 to make it work. 

Is there anyway to make it possible that the slicer accepts formats of 50% or 0,5? Thank you very much. 

2 Replies