Box and Whisker Plot - Don't Summarise Values

[Anonymous]

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.

Any advice would be appreciate.

Thank you

[v-luwang-msft · Accepted solution]

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.

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