Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm trying to adjust the data, however all modeling features are gray. How can I activate these features to use them? I want to change the formatting of the numbers from dollars and cents to whole dollars.
Thank you!
Solved! Go to Solution.
@nicoleeee Are you using a Live Connection? Many features are disabled when using live connection or direct query because the expectation is that you are doing that in the backend.
@nicoleeee Are you using a Live Connection? Many features are disabled when using live connection or direct query because the expectation is that you are doing that in the backend.
@Seth_C_Bauer, thank you for that information. We are using a live connection to a SQL Server Database. I will need to have IT update the coding then.
@nicoleeee You can go that approach, another one would be to create a measure from the column and format it however you would like. But, in an ideal world if you will be using the metric alot it should be in the correct format so you don't have to build measures just for formatting.