Forum Discussion
Box plot not showing correct mean
I have a measure that calculates the difference between 2 dates - columns. It returns me the number of days, as a numeric value.
Next i try to plot the measure on a boxplot. I use "Box and Whisker by MAQ Software" visual.
I put my measure in Values. But the boxplot doesn't show anything.
I put the same measure also in Axis.
Now the boxplot correctly visuales the data points, the min and the max. But the mean and the average are incorrect.
When using a card to show the average, the result is correct. So the measure is correct, but the visual is not showing it as it should.
Any help please?
Thanks
Hi @Ptolemaida,
As we haven’t heard back from you, we wanted to kindly follow up to check if your issue is resolved?
If not, please provide sample data that covers your issue or question completely, in a usable format.
Thanks and regards,
Anjan Kumar Chippa
8 Replies
- PhilipTreacySuper User
You can't put a measure in the Axis for that visual. Are you sure that's what you are doing?
Please provide our PBIX file or at the least some screenshots showing the values in the visual's wells/fields.
regards
Phil
- PtolemaidaFrequent Visitor
- PhilipTreacySuper User
You can put your measure in the Value, but you need a dimension (e.g. Category, Region, ID etc) in the Axis or Axis Category, like this
Regards
Phil
- PtolemaidaFrequent Visitor
for ex the left graph: 7.13 is the correct mean (see card visual below). the box plot is showing 16
- PhilipTreacySuper User
- Praful_PotphodeSuper User
Hi Ptolemaida ,
Please try solution suggested by PhilipTreacy .
If it doesnt work, please share sample pbix with input/output.
Thanks and Regards,
Praful
- v-achippaCommunity Support
Hi Ptolemaida,
Thank you for reaching out to Microsoft Fabric Community.
Thank you PhilipTreacy and Praful_Potphode for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user for the issue worked?
If not, please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.Need help uploading data? https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Thanks and regards,
Anjan Kumar Chippa
- v-achippaCommunity Support
Hi @Ptolemaida,
As we haven’t heard back from you, we wanted to kindly follow up to check if your issue is resolved?
If not, please provide sample data that covers your issue or question completely, in a usable format.
Thanks and regards,
Anjan Kumar Chippa