Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Displaying % as Ratio

Hi All,    I am trying to make a % visible in a different format.  E.g. Instead of 1.81% I want to show 1:50.   In Excel I use the following formula: "="1" & ":" & ROUND(($B$1/C1),0)" In Power ...
Need Help
Tips and Tricks
Tutorial Requests
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi Anonymous

     

    No worries, please see below the proposed solution.


    Here is the measure that I created

    Column E Result = "1:" & ROUND(CALCULATE(SUM('Table1'[A])/SUM('Table1'[B])),0)

    And this is what the result looks like

     

GilbertQ's avatar
GilbertQ
Super User
9 years ago

Perfect, glad it solved your issue.

choiyn98's avatar
choiyn98
Frequent Visitor
3 years ago

Could you help me with my scenerio? 

I created a Matrix in PBI and I want to calucate the ratio between 2023 with 2022 and another column for 2023 with 2021.

 

 

 

The result I want is to show % change between 2023 with 2022 and another column for 2023 with 2021.

 

% Change with last year

-8%

-13%

5%

-48%

24%

-25%

14%

56%

-11%

-5%

% Change with 2 years

-25%

-11%

88%

-36%

20%

-15%

-31%

21%

97%

4%

 

 

 

Thanks in advance!