Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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).

 

 

 

 

What I'm doing wrong here?

 

Thanks!

 

Need Help

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

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

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi Anonymous,

     

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

    If you set data type as:

    Please check.

     

    Best Regards,

    Link

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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!

    • v-xulin-mstf's avatar
      v-xulin-mstf
      Community Support
      5 years ago

      Hi Anonymous,

       

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

       

      Best Regards,

      Link

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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:

         

         

         

         

         

         

         

         

         

         

         

         

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

         

         

         

         

         

         

         

        This are my regional settings in the PBI: