Forum Discussion

Winston_Lai's avatar
Winston_Lai
New Member
7 years ago
Solved

Violin Plot (1.2.0) Plots Graph with Wrong Data

Hi everyone!

 

Recently I installed the extension "Violin Plot (1.2.0)" from the market place. I plotted the violin plot to visualize the quantity distribution by month. However, after I right clicked on the produced graph and clicked on the "Show Data" button, I saw that there is a wrong data in the data table, which casued to the wrong plots as well.

 

The screenshot of that particular row of data with the violin plot could be accessed via the OneDrive Link.

  • dm-p's avatar
    dm-p
    7 years ago

    Hi Winston_Lai ,

    It's hard to determine everything from your screenshot, but I'd suggest the following:

    • Put the Index column in the Sampling field - this is to ensure that all rows are unique going into the visual
    • Put your Month column in the Category field
    • Put your Quantity column in the Measure field

    If this is still causing you trouble, please feel free to share your workbook with me privately - my contact details are on the repo wiki - and I will try to set up an appropriate configuration for you to illustrate.

    In terms of further resources, the wiki or the sample report on AppSource fully document the visual and its capabilities.

    Best of luck,

    Daniel

11 Replies

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support

    Hi Winston_Lai ,

     

    Could you please describe the criteria to judge the exported data is wrong? What is your desired result? You can share your sample data or desired output in screenshots for further analysis.

     

    Best Regards,

    Amy

    • Winston_Lai's avatar
      Winston_Lai
      New Member

      Hi Amy,

       

      Referring to the screenshot: https://1drv.ms/u/s!AmY23HMj-m0In-49hOOUYGqKXmu9gw 

       

      The correct data as per loaded into Power BI is "1164, March" whereas Violin Plot takes it as "2328" for plotting, which is incorrect. I have plot exactly the same set of data for normal bar chart, it shows correctly as "1164". And there is only one record "1164" in March.

       

      Thank You & Best Regards

      Winston Lai

      • v-xicai's avatar
        v-xicai
        Icon for Community Support rankCommunity Support

        Hi Winston_Lai ,

         

        Maybe there are two records for the same "1164, March" , and them are summarized automatically? You can check the truth in Data view.

         

        Best Regards,

        Amy