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

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