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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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