Modeling Features are Gray

[nicoleeee]

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!

[Seth_C_Bauer · Accepted 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]

@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.

[Seth_C_Bauer]

@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.