Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Gauge Data Type Format

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,

Need Help

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    What's the question?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

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

     

    This is the best solution. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      Anonymous 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 %?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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.