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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Box and Whisker Plot - Don't Summarise Values

Hi there,

 

I have imported this Box and Whisker visualisation (https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380831?src=office&tab=Overview) into my report and am trying to show the distribution of dollar amounts across catergories.

 

However, when using the dollar figure value as a column, it is aggregating it. This means there is no range in the box and whisker plot as it's all averaging to one figure er category.

 

bh21_0-1648684644484.png

 

bh21_1-1648684660698.pngbh21_2-1648684672307.png

 

 

Any advice would be appreciate.


Thank you

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

Hi @Anonymous ,

In Box and Whisker by MAQ Software, 'Do not Summarize' option is not needed as providing a primary key or any field which can distinguish one data from another, in 'Axis' field will resolve your issue.

vluwangmsft_0-1649041797803.png

 

If question still not solved ,could you pls share your pbix file and remember to remove confidential data.

 

You can also review the solution provided by us to another user with similar issue  http://community.powerbi.com/t5/Desktop/How-to-use-quot-Box-and-Whisker-chart-by-MAQ-Software-quot/m...

https://community.powerbi.com/t5/Desktop/Data-Summarisation-with-Box-and-Whisker-Plots/m-p/2098516 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

View solution in original post

1 REPLY 1
v-luwang-msft
Community Support
Community Support

Hi @Anonymous ,

In Box and Whisker by MAQ Software, 'Do not Summarize' option is not needed as providing a primary key or any field which can distinguish one data from another, in 'Axis' field will resolve your issue.

vluwangmsft_0-1649041797803.png

 

If question still not solved ,could you pls share your pbix file and remember to remove confidential data.

 

You can also review the solution provided by us to another user with similar issue  http://community.powerbi.com/t5/Desktop/How-to-use-quot-Box-and-Whisker-chart-by-MAQ-Software-quot/m...

https://community.powerbi.com/t5/Desktop/Data-Summarisation-with-Box-and-Whisker-Plots/m-p/2098516 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors