Forum Discussion

christinas's avatar
christinas
Helper I
8 months ago
Solved

Gauge Visual

Hello community, I am new to PBI and would appreciate any help. I have results for an employee engagement survey. Excel is formatted so each row is one employee and the columns are employee info as ...
  • Anonymous's avatar
    Anonymous
    8 months ago

    Hi christinas ,

    Try below measure.

     

    Individual Score =

    AVERAGEX (

        'Survey',

        ('Survey'[Q1. I feel my work is meaningful and contributes to the company's success] +

         'Survey'[Q2. I am able to balance my work and life] +

         'Survey'[Q3. I am satisfied with my current job])

    / 3

    )

     

    In the Gauge Visual,

     

    Value → Individual Score

     

    Minimum → 1

     

    Maximum → 6

     

    Target value → your benchmark (e.g., 4.5)

     

    If you want to show Each Question as Bars

     

    Create three measures:

     

    Q1 Score = AVERAGE('Survey'[Q1. I feel my work is meaningful and contributes to the company's success])

    Q2 Score = AVERAGE('Survey'[Q2. I am able to balance my work and life])

    Q3 Score = AVERAGE('Survey'[Q3. I am satisfied with my current job])

     

     

    Use a clustered bar chart with these measures.

     

    If my response as resolved your issue please mark it as solution and give kudos.