Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have two value i want to display.
First: Price per quarter
Second: Price change in percentage vs last quarter.
Ideally i would like to display for both but it seems power bi only allow one line series. It basically summarizes the price change in percentage for all my products into one line.
Can someone help me?
Data set:
Table 0.Product | Product Price by Quarter | Year | Quarter | Month | Day | % Change in Price vs LQ |
Prod1 | 1.785 | 2017 | Qtr 4 | October | 1 | |
Prod1 | 1.85 | 2018 | Qtr 1 | January | 1 | 3.51% |
Prod1 | 1.88 | 2018 | Qtr 2 | April | 1 | 1.60% |
Prod1 | 1.84 | 2018 | Qtr 3 | July | 1 | -2.17% |
Prod1 | 1.77 | 2018 | Qtr 4 | October | 1 | -3.95% |
Prod2 | 3.15 | 2017 | Qtr 4 | October | 1 | |
Prod2 | 3.1 | 2018 | Qtr 1 | January | 1 | -1.61% |
Prod2 | 3.1 | 2018 | Qtr 2 | April | 1 | 0.00% |
Prod2 | 3.125 | 2018 | Qtr 3 | July | 1 | 0.80% |
Prod2 | 3.1 | 2018 | Qtr 4 | October | 1 | -0.81% |
Prod3 | 0.7325 | 2017 | Qtr 4 | October | 1 | |
Prod3 | 0.675 | 2018 | Qtr 1 | January | 1 | -8.52% |
Prod3 | 0.6 | 2018 | Qtr 2 | April | 1 | -12.50% |
Prod3 | 0.6075 | 2018 | Qtr 3 | July | 1 | 1.23% |
Prod3 | 0.557 | 2018 | Qtr 4 | October | 1 | -9.07% |
Prod4 | 2.278 | 2017 | Qtr 4 | October | 1 | |
Prod4 | 2.232 | 2018 | Qtr 1 | January | 1 | -2.06% |
Prod4 | 2.248 | 2018 | Qtr 2 | April | 1 | 0.71% |
Prod4 | 2.22 | 2018 | Qtr 3 | July | 1 | -1.26% |
Prod4 | 2.148 | 2018 | Qtr 4 | October | 1 | -3.35% |
Solved! Go to Solution.
@Anonymous ,
There is already an idea, you may leave a comment and vote it up.
@Anonymous -
I don't think that's an option in the line and column chart.
One potential solution is to overlay a line chart on top of a column chart. It will be very busy, though
Cheers!
Nathan
Hi Natel,
Thanks for your advice!
That is unfortunate. I remembered that excel has this functionality on combo charts.
Regards,
Jason
@Anonymous ,
There is already an idea, you may leave a comment and vote it up.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
139 | |
104 | |
104 | |
80 | |
66 |