How can I have both 2018 and 2019 lines on the figure at the same time? Thanks in advance!
Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I was trying to have two line charts on the same figure. However, the visualization only shows one line.
Here're the fields I have in the python visual, Spend 2018 and Spend 2019 are measures:
Here's my code in the python script editor:
# The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your script: # dataset = pandas.DataFrame(Week of,Year,Spend 2018, Spend 2019) # dataset = dataset.drop_duplicates() # Paste or type your script code here: import matplotlib.pyplot as plt line1 = dataset.plot('Week of','Spend 2018',color="#333333") line2 = dataset.plot('Week of','Spend 2019',color="#999999") plt.show()
How can I have both 2018 and 2019 lines on the figure at the same time? Thanks in advance!
I think this is happening because the way it is set up you are trying to plot to two different axes. You need to get the current axes and plot to it.
Try something like this:
# The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your script: # dataset = pandas.DataFrame(Week of,Year,Spend 2018, Spend 2019) # dataset = dataset.drop_duplicates() # Paste or type your script code here: import matplotlib.pyplot as plt
ax = plt.gca() line1 = dataset.plot('Week of','Spend 2018',color="#333333", ax=ax) line2 = dataset.plot('Week of','Spend 2019',color="#999999", ax=ax) plt.show()
Hi @Anonymous ,
After researching, I haven't solved it. Maybe others who experienced it will help you. Or you might try to create a support ticket to get a dedicated support.
Hope your problem will be solved as soon as possible. If you have solved it by yourself, welcome to share your solution. Many people will benefit here.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
73 | |
70 | |
38 | |
23 | |
23 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |