topic Re: Modeling Features are Gray in Desktop

Modeling Features are Gray

nicoleeee — Thu, 12 Oct 2017 21:08:22 GMT

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!

Re: Modeling Features are Gray

Anonymous — Thu, 12 Oct 2017 23:40:11 GMT

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.

Re: Modeling Features are Gray

nicoleeee — Fri, 13 Oct 2017 00:06:43 GMT

Anonymous, 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.

Re: Modeling Features are Gray

Anonymous — Fri, 13 Oct 2017 16:22:40 GMT

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.