Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

How to do Number Formatting for Visual Calculations

Is there a way to do a number formatting for visual calculations?   It seems to follow the original measure, but when I do a divide to get a % of Total I want to present a percentage. Currently tha...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  Anonymous 

 

Idrissshatila , thanks for your concern about this case.

 

Do you want the points on each line to show their respective values? I did the following test using sample data, hope it helps.

 

I created two measurements and a visual calculation just to reproduce the steps you did.

 

two measures:

 

sum = CALCULATE(SUM(financials[Profit]), ALLEXCEPT(financials, financials[Country]))
total = CALCULATE(SUM(financials[Profit]), ALL(financials))

 

 

Visual Calculations:

 

Then I turned on the Data labels option.

 

Result:

 

Best Regards,
Yulia Xu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I think you missed the point of the question. You haven't shown how to format the number as a percentage.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Anonymous 

       

      After my testing, Tooltip is not able to customize the format.

       

      The following ways are for your reference.

       

       

       

       

      Result:

       

      Best Regards,
      Yulia Xu

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.