Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I can't seem to change the format of displayed numbers.
The options in the modelling tab are greyed out.
Data is formated as fixed decimal in the query (which is just a CSV load).
Any suggestions?
Solved! Go to 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.
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.
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.
Just starting out to use Power BI, what do you mean by highlighting the Fields Sector?
Thanks
Hello,
see print.
Thank you , been stuck all morning on this ! 🙄
THank you very much!
Thank You!!! I've been trying to figure that out for days.
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.
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
Thanks for the solution
YES!! This really helps!!
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.
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!