Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |