Forum Discussion

GhadaMehrez's avatar
GhadaMehrez
Icon for Helper III rankHelper III
4 years ago

Convert field into percentage

I need to convert field value into percentage but when I choose to show value as a percentage I got all values as 100% which is not right:  
Need Help
jennratten's avatar
jennratten
Icon for Super User rankSuper User
4 years ago

Okay, if you can't transform the data in Power Query then you should create a measure and then assign the data type to the measure.  Then replace the column value in the visual with the measure.  Create additional measures for any other calculations and add those to your visuals as well.

In #3 below, change the aggregation function to one that is relevant for your scenario.

 

GhadaMehrez's avatar
GhadaMehrez
Icon for Helper III rankHelper III
4 years ago

Thanks a lot I followed the steps for the measure but for the aggregation function I

put Value I don't know if it the right one I just select Estimated cost field and filtered by project and created the measure but I still have the wrong percentage, any advice?

 

%ETC = VALUE( (CustomCulculations[Actuals Booked]))

 

  • jennratten's avatar
    jennratten
    Icon for Super User rankSuper User
    4 years ago

    Please try these:

    This one for the percent value

    % ETC = count(CustomCulculations[Actuals Booked])

    This one for the number value

    # ETC = count(CustomCulculations[Actuals Booked])

     

    • GhadaMehrez's avatar
      GhadaMehrez
      Icon for Helper III rankHelper III
      4 years ago

      something is wrong here:

       

      • jennratten's avatar
        jennratten
        Icon for Super User rankSuper User
        4 years ago

        Try this one instead:  count(Portfolios[pum_Name])