cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
arpitkumar2310 Frequent Visitor
Frequent Visitor

show numbers as fraction

How to show a number in a "New Measure" as a Fraction or Ratio?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
hugoberry Member
Member

Re: show numbers as fraction

The general algorithm would be for the example that you've given.

Given : 2.5

1. Represent the number as a fraction : 25/10 

2. Find GCD(25,10) =  5

3. Divide both the numerator and denominator by GCD=5

Result: 5/2

 

It's up to you  to choose the precision. Here is my take on some DAX

Fraction =
var given=2.5
var precision=100000
return (given*precision/GCD(given*precision,precision))&"/"&(precision/GCD(given*precision,precision))

View solution in original post

6 REPLIES 6
Datatouille Established Member
Established Member

Re: show numbers as fraction

Hi @arpitkumar2310

 

What do you mean exactly ?

You can use the symbol "/" or, even better, the DAX function Divide in your measures.

 

You can then display the measure as percentage in 'Modeling' > Formatting.

arpitkumar2310 Frequent Visitor
Frequent Visitor

Re: show numbers as fraction

@Datatouille:

 

Currently I am using it as 

 

Measure = format(2.5,"0.0%")

 

Which will display it as 250.0% but I want it to display it as 5 / 2 or 5 : 2.

v-ljerr-msft Super Contributor
Super Contributor

Re: show numbers as fraction

Hi @arpitkumar2310,

 

As there is no option to set number format for a measure to Fraction in 'Modeling' > Formatting currently, I would suggest you to submit your requirement on Power BI Ideas and vote it up to improve Power BI on this feature.Smiley Happy

 

Regards

arpitkumar2310 Frequent Visitor
Frequent Visitor

Re: show numbers as fraction

iHi @v-ljerr-msft,

 

Sure. Thank you.

Highlighted
hugoberry Member
Member

Re: show numbers as fraction

The general algorithm would be for the example that you've given.

Given : 2.5

1. Represent the number as a fraction : 25/10 

2. Find GCD(25,10) =  5

3. Divide both the numerator and denominator by GCD=5

Result: 5/2

 

It's up to you  to choose the precision. Here is my take on some DAX

Fraction =
var given=2.5
var precision=100000
return (given*precision/GCD(given*precision,precision))&"/"&(precision/GCD(given*precision,precision))

View solution in original post

arpitkumar2310 Frequent Visitor
Frequent Visitor

Re: show numbers as fraction

Hi @hugoberry,

 

Thank you so much!! That was amazing.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 218 members 2,363 guests
Please welcome our newest community members: