Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |