Box plot not showing correct mean

[Ptolemaida]

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

[v-achippa]

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-...

Thanks and regards,

Anjan Kumar Chippa

[v-achippa · Accepted solution]

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

[Praful_Potphode]

Hi @Ptolemaida ,

Please try solution suggested by  @PhilipTreacy .

If it doesnt work, please share sample pbix with input/output.

Thanks and Regards,

Praful

[Ptolemaida]

for ex the left graph: 7.13 is the correct mean (see card visual below). the box plot is showing 16

[PhilipTreacy]

@Ptolemaida 

How are you calculating the mean that gives the result of 7.13?

Phil

[PhilipTreacy]

@Ptolemaida 

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

[PhilipTreacy]

@Ptolemaida 

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

[Ptolemaida]