Power BI community
With new Jan release, I would like to use Box and Whisker chart by MAQ Software visual properly
I am currently showing the average price of each product by would like to show Max price and Min price as well.
How can I achieve this using the new "Box and Whisker chart by MAQ Software"??
Solved! Go to Solution.
As the visual cannot distinguish between one price of August 3rd to another price of August 3rd, so the visual was providing data as a sum. We have assumed that the 'Tempo Name' field is able to distinguish between these two prices.
So for brand 'Baby Danone' and SKU 'BD Green Veg' for August 3rd 2017, the data is
Min - 178
Max - 268
Average - 222.52
Which we can easily display by providing 'Tempo Name' in Axis field -
If 'Tempo Name' is not the correct field, then just provide any primary id which can distinguish between the data.
We have gone through your data, but we were unable to understand your requirement.
Please provide the items listed below so that we can reproduce the issue and further investigate it:
Detailed description of requirement
Providing the details listed above will help us better prioritize this issue in our backlog and address it sooner.
We can be reached at email@example.com
Hello. Thank you for your response.
I have created a simple sample data such as below.
Here is what I would like to do.
This last step I am struggling with.
Thank you for your support!
Just add 'Product' to 'Axis' field, as shown in the snapshot.
Here max price is value shown in front of Maximum, min price is value shown in front of minimum and Arithmetic mean is the average.
Please reach out to us at firstname.lastname@example.org for any further queries.
Thank you for the response.
The problem with this is that the visual is not showing the max and min value of the product.
It is showing the summation of the price.
For instance, in below shot, based on the data,
I would like to see a visual with the following for Jan (Carmelo 1)
Thank you for your help!
Just provide 'Check Date' in 'Axis' and 'Axis Category I'; 'Product' as 'Axis Category II' and 'Price' as 'Value' as shown in snapshot below -
For further information please download the User Guide of Box and Whisker by MAQ Software from here
If the information meets your needs, then we would greatly appreciate it if you posted your review of this visual at AppSource.
Thank you for the reply and the manual on how to use.
With the sample data set provided, your solution works perfectly.
However, with my actual dataset, the price is summing up.
I have set up the rows and columns as you mentioned.
I am not sure why the price is summing up.
i’m also interested in the visual. Is there any way to display the max/min/average values in the visual (apart from the tooltips)?
It would be great if you could, and also enable the option of which values to dsiplay in the tooltips itself.
I would like to use the visual to display simple values stated above, to reflect max/min/average prices, and it would be more user friendly if the option to actually see the values was available, and lower the “clutter” (in my instance) within the tooltips.
Max, Min and Average are already shown in the visual as shown in the snapshot below
For tooltips visible when we hover on dots, all fields are necessary to identify the dot.
For tooltips visible when we hover on Box and Whisker, we have added your request to our backlog. Please reach out to us with detailed description regarding which fields you want to display at email@example.com