topic Re: Formatting decimal separator in Custom Visuals Development Discussion

Formatting decimal separator

liselotte — Tue, 22 Oct 2024 12:53:27 GMT

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.

Re: Formatting decimal separator

lbendlin — Sun, 27 Oct 2024 12:11:02 GMT

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 .

Re: Formatting decimal separator

liselotte — Sun, 27 Oct 2024 14:15:17 GMT

Thank you for your recommendation. I'll rise a ticket for Power BI Support. 🙂