Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Python visual is not accurate

The matplotlib plot that shows up in Power BI, is different from that one, that the same code generates in a jupyter notebook. Please help.
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Thank you Pragati11  and amitchandak .

    The issue was with the sequence of columns. Power BI sends the columns in the alphabetical order, and not in the order in which the columns get uploaded.

    Thanks again for your prompt support.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Checked again, Pragati11 . Each one of them is set to "Don't Summarize".

Pragati11's avatar
Pragati11
Super User
5 years ago

Hi Anonymous ,

 

Is it possible to share your pbix file?

 

Thanks,

Pragati

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Pragati11 ,

    Hope you can access the files from here.

    Dropbox 

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    Hi Anonymous ,

     

    Yes I can access them. Let me check and get back to you on this. 🙂

     

    Thanks,

    Pragati

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    Hi Anonymous ,

     

    I get following error on your script:

     

    Is it working at your end?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Pragati11 ,

     

    Must be something with the settings. It is working just fine. Please refer to the attached screenshot.

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    Hi Anonymous ,

     

    I am not sure. there doesn't seem to be a setting issue.

    I tried a case at my end by using xlim and it seems to work just fine at my end.

    See below my original chart:

     

    Now I set a limit on my x-axis and I get the following:

    The only different thing I have used in my code is ax = plt.gca() to get the current axis and then apply limit on the axis range.

     

    Can you try adding that in your python script and check it?

     

    Thanks,

    Pragati