Percentile and format

Question

Hi All,&nbsp;I am trying to build a virtual table to compare a value (1st column) and its 90th percentile (2nd column). I am having an issue due to the format of the percentile. I took a step back and created a measure for the 90th percentile to better understand its behaviour. I got the confirmation the measure was by default considered as "text", with no possibility to change the format.&nbsp; Do you guys have any idea how to fix that?&nbsp;The colum on which the measure is based on is in "whole number" format.&nbsp;Here is my measure:&nbsp;Thanks in advance&nbsp;

amitchandak · Answer

Refer :https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

arnault_ · Answer

Hi&nbsp;amitchandak&nbsp;,&nbsp;Thank you for your answer. As I said, I would like to use this measure within a virtual table. I know there are several ways to change the format but it cannot be applied in a virtual table. I found a workaround and forced the measure to be of a numeric type using VALUES(). Yet, I don't understand that behaviour with Percentile function in DAX. I am sure it has something to do with blank values.Cheers

Forum Discussion

Percentile and format

2 Replies

Related content

Conditional formatting based on percentile value

Percentile

Percentile

Calculate percentile between tables

Conditional formatting using percentiles in a matrix