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

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

 

Ashish_kumar12's avatar
Ashish_kumar12
Helper I
6 years ago

Hi  GilbertQ  , Can you please assist me in my scenario.

 

I have created a ratio and am trying to place it in MATRIX visual as have to display data in following manner -

 

Consultant

Total Leads submitted

Count of Approved Leads but no orders

Leads not approved

Count of Approved Leads and orders Placed

Total Leads : Approved Leads and orders Placed

A

47

2

35

10

=Round(47/10,0)   &":1"

= 5 : 1

B

20

5

5

10

2 : 1

 

When I am trying to do the same in matrix visual it is not happening. When I place ratio without the columns with count then it is working - image below is as per data of Consultant A above

 

 

 

Also, another query is, since it is creating ratio in text format, I wish to sort the ratios with lowest ratio on top to highest ratio.

Example: instead of 2:1, 37:1 then 5:1 wish to display information as 37:1, 5:1 then 2:1

 

Please let me know.

 

Thanks.

Regards,

Ashish