cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mhasanbulli Regular Visitor
Regular Visitor

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.

1.png

 

 

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.

 

2.png

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Years Get Thousand Separation in Power BI Service

@mhasanbulli 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?

 

 


Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Years Get Thousand Separation in Power BI Service

Hi there

 

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

 

Power BI - Do Not Summarize.png

I would then also check the settings in the Service.

 

 


Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
mhasanbulli Regular Visitor
Regular Visitor

Re: Years Get Thousand Separation in Power BI Service

Hello,

 

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

 

1.png

 

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

Super User
Super User

Re: Years Get Thousand Separation in Power BI Service

@mhasanbulli 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?

 

 


Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

View solution in original post

mhasanbulli Regular Visitor
Regular Visitor

Re: Years Get Thousand Separation in Power BI Service

@GilbertQ It seems like that is the reason. When I view the y-axis properties, years is parsed as "Continuous" variable.\

2.png

 

 

Changing the type to "Categorical" fixes the dates. 

3.png

 Thank you very much for the help. I guess I have a long way to learn all these little tricks Smiley Happy

 

 

Super User
Super User

Re: Years Get Thousand Separation in Power BI Service

@mhasanbulli not a problem at all, we are all always learning, so glad to assist.


Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 200 members 2,046 guests
Please welcome our newest community members: