Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
JuliaF
Frequent Visitor

Percentiles calculated with Measures vs. MAQ Box and Whisker Plot Visual

Hello everyone!
I’ve tested MAQ Box and Whisker Plot Visual recently and I’ve noticed that the percentiles (the 10th and the 90th) are different from those what are calculated with measures. And furthermore, the 1th and the 3th quartiles, the mean and the median match with the values calculated with measures. I wonder whether it's a bug on the plot, because I have no additional filters that could influence the numbers.

Any recommendation on how to fix this? Thanks.

 

1D = PERCENTILE.INC('Table'[Category]; 0,1)

9D = PERCENTILE.INC('Table'[Category]; 0,9)

1Q = PERCENTILE.INC('Table'[Category]; 0,25)

3Q = PERCENTILE.INC('Table'[Category]; 0,75)

Median = Median('Table'[Category])

Mean = Average('Table'[Category])

 

HqWqImc960OEBuebu1yDYg.png

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

HI @JuliaF,

I think they may relate to custom visual designs, perhaps you can contact the visual author to report this.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
FannyZ
Frequent Visitor

Hello,

 

I face hte same issues, any updates were made or solutions found to solve this? 
Thank you

v-shex-msft
Community Support
Community Support

HI @JuliaF,

I think they may relate to custom visual designs, perhaps you can contact the visual author to report this.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.