Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Guage Percenatge

My guage is show like this instead of a percentage:

 

 

 

This is the measure:

  

It's set to 'no calculation', if I set it to 'percentage' it goes to 100.

 

 

 

 

 

% of responses which are positive =
DIVIDE (
    CALCULATE (
        [Total Responses],
        FILTER (
            'CSAT Survey Data 2017',
            'CSAT Survey Data 2017'[Satisfaction Level] = "Excellent"
                || 'CSAT Survey Data 2017'[Satisfaction Level] = "Good"
        )
    ),
    [Total Responses],
    0
)

 

  • Anonymous's avatar
    Anonymous
    9 years ago

    Select your Measure or Column that forms this value.  What data type is it?  You can see this from the Modeling tab in the ribbon.  It should be formatted as a Percentage.

  • Hi Anonymous,

     

    As Ross73312 said, you can format the measure value under the Modeling tab. Please see below image.

     

    Best regards,
    Yuliana Gu

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Select your Measure or Column that forms this value.  What data type is it?  You can see this from the Modeling tab in the ribbon.  It should be formatted as a Percentage.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi Anonymous,

     

    As Ross73312 said, you can format the measure value under the Modeling tab. Please see below image.

     

    Best regards,
    Yuliana Gu