Forum Discussion
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.
Any advice would be appreciate.
Thank you
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 RegardsLucien
1 Reply
- v-luwang-msft
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.
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 RegardsLucien