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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
tcm2007
Advocate I
Advocate I

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

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

16 REPLIES 16
Greg_Deckler
Super User
Super User

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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.

Anonymous
Not applicable

Just starting out to use Power BI, what do you mean by highlighting the Fields Sector?

 

Thanks

Hello,

 

see print.

IonitaA_0-1616495802168.png

 

Anonymous
Not applicable

Thank you , been stuck all morning on this ! 🙄

Anonymous
Not applicable

THank you very much!

Thank You!!!  I've been trying to figure that out for days.

Anonymous
Not applicable

You saved me much time! Thanks!

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

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

Anonymous
Not applicable

Thanks for the solution

Anonymous
Not applicable

YES!! This really helps!!

Anonymous
Not applicable

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,

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.

Anonymous
Not applicable

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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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