Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Percentage based bar chart?

  I would like to make bar chart where customersatisfaction is based on percentage so that it is scaled based on max value. So Toyota have 100% satisfaction and Nissan 50%.    CustomerName, TimeS...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Anonymous,

     

    I have tested it on my side, your formula works fine for me. Note: make sure you have change the Type of Y-Axis to Categorital in Format tab for the bar Chart.:smileyhappy:

     

    Here is the sample pbix file for your reference.

     

    Regards

Thiyags's avatar
Thiyags
Helper II
9 years ago

You have to create 2 measures . 1 measure to find the max value and 2 nd measure to divide with the max value

 

1. MaxCustomer Satisfaction = CALCULATE(MAX(CS[Customer Satisfaction]),ALL(CS[Customer Name]))

 

2. CustomerSatisfactionPercentage = DIVIDE(SUM(CS[Customer Satisfaction]),[MaxCustomerSatisfaction])

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I tried, but not looking good.

 

Is it so that purpose of MaxCustomerSatisfaction is add value "130" to each row as reference value? (basically highest value of all)

And is it so that purpose of CustomerSatisfactionpercentage is show percentage of the row compared to MaxCustomerSatisfaction like 100% or 50%

 

What I see is that MaxCustomerSatisfaction value for each row is varying and highest value is 1.

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi Anonymous,

     

    The formulas provided by Thiyags should work. You should use the formulas to create two measures instead of calculate column.

     

     

    Here is the sample pbix file for your reference.:smileyhappy:

     

    Regards

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Sorry. You advice seems to be very correct. But could not apply as I used to simple scenario.

       

      This is the real case.

       

      emotionTable

      PartitionKey, RowKey, Timestamp, Happiness

      000000000001,1, 05/12/2016 13:01:01, 0,9999

      000000000002,2, 05/12/2016 14:02:01, 0,0100

      000000000003,3, 05/12/2016 15:03:01, 0,0001

      000000000004,4, 05/12/2016 16:04:01, 0,0100

      000000000005,5, 05/12/2016 16:05:01, 0,0001

      000000000006,6, 06/12/2016 13:01:01, 0,0001

      000000000007,7, 06/12/2016 13:02:01, 0,0200

      000000000008,8, 06/12/2016 14:03:01, 0,0001

      000000000009,9, 06/12/2016 14:04:01, 0,0300

      0000000000010,10, 06/12/2016 13:04:01, 0,0100

       

      Measures:

      MaxHappiness = CALCULATE(MAX(emotionTable[Content.Happiness]),ALL(emotionTable[Timestamp]))

      HappinessPercentage = DIVIDE(SUM(emotionTable[Content.Happiness]),[MaxHappiness])

       

      I expected that all bar in chart in MaxHappines would be 0,999(row1) to be used as referenced value.

      But what I see is all bars showing value 1.0. Obviouly something wrong with my MaxHappiness measure.

       

      Target raports:

      1) I see happiness percentage per timestamp. (Tells happiness by moment)

      2) I see happiness average happiness percentage by hour. (I see happiness level by hour)

      • v-ljerr-msft's avatar
        v-ljerr-msft
        Microsoft Employee
        9 years ago

        Hi Anonymous,

         

        I have tested it on my side, your formula works fine for me. Note: make sure you have change the Type of Y-Axis to Categorital in Format tab for the bar Chart.:smileyhappy:

         

        Here is the sample pbix file for your reference.

         

        Regards