CODEWITHSUNDEEP
powerbi
asmgx
asmgx

Reputation: 8004

Show 90% percentile in Bar Charts Power BI

My Data is like this

User_ID  Stage_1  Stage_2  Stage_3  StagesTotal
---------------------------------------------------
U000     3        9        8        20
U111     5        7        2        14
U222     3        6        5        14
U333     6        5        8        19
U444     8        4        6        18
U555     2        7        7        16
U666     5        5        4        14

------------------------------------------------------

I have a bar chart that shows the median

enter image description here

That is good

instead of the median i want to show the 90% percentile

I tried creating a new measures 

Stage1_90Perc = PERCENTILE.EXC(Stages[Stage1],90)
Stage2_90Perc = PERCENTILE.EXC(Stages[Stage2],90)
Stage3_90Perc = PERCENTILE.EXC(Stages[Stage3],90)
StagesTotal_90Perc = PERCENTILE.EXC(Stages[StagesTotal],90)

When I add the new meseare to my chart it breaks

enter image description here

it becomes like this

enter image description here

bu the chart turns to this

enter image description here

my question is how to display the 90% percentile in that report data

Note : the 90% measure will be used in many other charts once it is fixed

Upvotes: 0

Views: 480

Answers (1)

pensum
pensum

Reputation: 1019

You have entered what I believe to be a simple mistake where you wrote (Stages[Stage],90) : 

Stage_90Perc = PERCENTILE.EXC(Stages[Stage],90)

It should be this instead : 

Stage_90Perc = PERCENTILE.EXC(Stages[Stage], .90)

Upvotes: 1

Related Questions