Forum Discussion

Ptolemaida's avatar
Ptolemaida
Frequent Visitor
8 months ago
Solved

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

  • 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 

     

    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

     

  • Ptolemaida's avatar
    Ptolemaida
    Frequent Visitor

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

  • v-achippa's avatar
    v-achippa
    Community 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-achippa's avatar
      v-achippa
      Community 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