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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Between slicer using a komma

Hi all,

 

In my PBI report I'm using the between slicer. In this slicer i'm using a kolom with a decimal value. this way the user can filter the context by there value. My windows setting is in dutch en also my power BI server setting. Still it looks like the slicer is behaving like it is in English, because I have to use a dot '.' instead of a komma ',' for inserting changing the decimal number (see in the blue).

 

Slicer 1.pngSlicer 2.png

 

 

 

What I'm doing wrong here?

 

Thanks!

 

6 REPLIES 6
Anonymous
Not applicable

Hi Link,

 

The PBI has a live connection with a tubalur model.

My windows settings is Dutch. Al the other measures in the power BI I see like this 1.111,11.

So it looks like the power BI uses Dutch formatting. Expect in the slicer. 

 

Thanks!

Hi @Anonymous,

 

When you modify the region, does it show up as expected?

 

Best Regards,

Link

Anonymous
Not applicable

Hi,


No it doesn't. I just created a new PBI en created a kolom by

= GENERATESERIES(1,500,0.2)

The result I see is:

slicer test.PNG

 

 

 

 

 

 

 

 

 

 

 

 

When I put this kolom into the slicer, i see this again:

Slicer tes 2.PNG

 

 

 

 

 

 

 

This are my regional settings in the PBI:

regional settings.PNG

Hi @Anonymous,

 

It works well in my environment.

v-xulin-mstf_0-1614331062866.png

v-xulin-mstf_1-1614331095429.png

You can try to change to other region and check if it works.

 

Best Regards,

Link

 

 

v-xulin-mstf
Community Support
Community Support

Hi @Anonymous,

 

Even if I change the region, I still can't reproduce your issue.

If you set data type as:

v-xulin-mstf_0-1614308926523.png

Please check.

 

Best Regards,

Link

amitchandak
Super User
Super User

@Anonymous , This should work based on the regional setting.  You have created this after the regional setting has been done?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.