cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tcm2007 Frequent Visitor
Frequent Visitor

Unable to alter number formatting

I can't seem to change the format of displayed numbers.

 

The options in the modelling tab are greyed out.

 

Capture.PNG

 

Data is formated as fixed decimal in the query (which is just a CSV load).

 

Any suggestions?

1 ACCEPTED SOLUTION

Accepted Solutions
tcm2007 Frequent Visitor
Frequent Visitor

Re: Unable to alter number formatting

Figured it out; you have to highlight the field in the Fields selector, not by clciking on the numbers in the report. Not intuitive  to me.

View solution in original post

12 REPLIES 12
Super User
Super User

Re: Unable to alter number formatting

You are on the Report tab, try going to the data modeling tab (over on the left just below the column chart icon, the one that looks like a table), select your column and then go to Modeling tab in the ribbon.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

tcm2007 Frequent Visitor
Frequent Visitor

Re: Unable to alter number formatting

Figured it out; you have to highlight the field in the Fields selector, not by clciking on the numbers in the report. Not intuitive  to me.

View solution in original post

skylarw Frequent Visitor
Frequent Visitor

Re: Unable to alter number formatting

Thanks! I had the same problem and that fixed it!

Saung Frequent Visitor
Frequent Visitor

Re: Unable to alter number formatting

Could you please tell me more clearly. I don't understand what does 'you have to highlight the field in the Fields selector, not by clciking on the numbers in the report' mean. My Power be like below.

 

Capture.PNG

AReffoios Visitor
Visitor

Re: Unable to alter number formatting

Hey. 

 

I had the same problem. You need to go to the fields sector on the right and then click the field you would like to change (ex. City) and the modeling section will become available to edit 

Error 1.png

Irwest Regular Visitor
Regular Visitor

Re: Unable to alter number formatting

The solution you gave here doesn't help me. My "Modeling" is still grey and disabled. 

PS

I'm building my reports based on the Cube, maybe that's the reason of that?

 

Thanks,

klarsonef Frequent Visitor
Frequent Visitor

Re: Unable to alter number formatting

I had the same problem. Checking the box in the field selector isn't enough - you have to click onto the measure (as if you were going to edit the formula). Then, the Formatting option should appear available for you.

Highlighted
Irwest Regular Visitor
Regular Visitor

Re: Unable to alter number formatting

It will not appear, since I'm using the live connection and all my measures come from the cube. So, basicaly, the solution is o make all the formating at the cube level.

Thanks

Angeliki New Member
New Member

Re: Unable to alter number formatting

You saved me much time! Thanks!

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 64 members 1,291 guests
Please welcome our newest community members: