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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
liselotte
New Contributor III

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. 

1 ACCEPTED SOLUTION
lbendlin
Esteemed Contributor III

I seem to recall that this is a design limitation.

 

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

View solution in original post

2 REPLIES 2
lbendlin
Esteemed Contributor III

I seem to recall that this is a design limitation.

 

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

liselotte
New Contributor III

Thank you for your recommendation. I'll rise a ticket for Power BI Support. ๐Ÿ™‚

Helpful resources

Announcements
Top Kudoed Authors
Users online (6,086)