Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Years Get Thousand Separation in Power BI Service

Hi,

 

I have a date column in my table where the data type is Date as I would like to have drill downs on my charts. Everything seems to work great on Power BI Desktop. Below is a screenshot.

 

 

Whenever I publish my report to Power BI Service, the years get a thousand separator and the order is reversed for some reason. Drill down works, though. Here is a screenshot from Power BI Service.

 

 

Is this a known bug? Has anyone experienced anything like this?

  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Anonymous What I meant was in the Service if you can check what the data type is set to for years in Power BI Desktop.

     

    I am going to guess in that even though your date column is set to date, your Years data type is set to either Whole Number or Decimal Number, and has got the thousands seperator on that?

     

     

5 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    9 years ago

    Hi there

     

    On your data type is it set to Do Not Summarize under Modelling and then Default Sumarization as shown below?

     

    I would then also check the settings in the Service.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hello,

       

      Thanks for the reply. Yeah, I have checked "Do Not Summarize" and it is fine.

       

       

       I couldn't find anything related to that in the Service though. Which settings are you talking about?

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        9 years ago

        Anonymous What I meant was in the Service if you can check what the data type is set to for years in Power BI Desktop.

         

        I am going to guess in that even though your date column is set to date, your Years data type is set to either Whole Number or Decimal Number, and has got the thousands seperator on that?