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

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Awesome that workes! Thanks!

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!