Gauge Data Type Format

[Anonymous]

Hi Guys,

I have a gauge. which displays value in decimals and wanted to change it to %.

Which one is most suitable answer here?

Create a calculated column that adds the % symbol to the values.
From the Modeling tab, change the Data Type to Percentage.
Edit the query of the data source and change the Data Type to Percentage.
Create a measure that adds the % symbol to the values,

[cnweke]

From the Modeling tab, change the Data Type to Percentage.

This is the best solution. 

[Anonymous]

---

@cnweke wrote:

From the Modeling tab, change the Data Type to Percentage.

This is the best solution. 

---

This will not impact if same measure is getting used other places and other places I don't want to display in %?

[cnweke]

It will be a % everywhere but why would you want to show decimals to begin with?

Displaying 0.4 is a lot less intuitive than simply showing 40 % to end-users.

If this is really important make 2 measures calculating the same thing and set one to a % and keep the other one as a decimal.

[Anonymous]

---

@cnweke wrote:

It will be a % everywhere but why would you want to show decimals to begin with?

Displaying 0.4 is a lot less intuitive than simply showing 40 % to end-users.

If this is really important make 2 measures calculating the same thing and set one to a % and keep the other one as a decimal.

---

So in this case last is the right ans: Create a measure that adds the % symbol to the values

Correct?

[cnweke]

no, just create the same measure twice and change the datatype of one measure.

[Anonymous]

here is the difference if you change data type of a field and if you simply format the field:

[Anonymous]

What's the question?