Forum Discussion
Line Chart w/ 3 Lines & Measure
I am trying to figure out the way to add a line chart visual with two y axis. I need to show packages recieved and packages delivered on one axis and then on the second axis I want to show a comparison between the two using the following; [(Packages Received - Packages Delivered)/Packages Delivered]. I can get the first part of this pretty easily with a standard line chart, but I am having a difficult time creating the measure for the last part and placing it on its own axis. Below is a sample from my data. Thank you so much for your help!
| Facility | Packages | Receipt/Delivery | Month |
| Redbud | 11001 | R | Jan-20 |
| Redbud | 12103 | D | Jan-20 |
| Redbud | 12000 | R | Feb-20 |
| Redbud | 11542 | D | Feb-20 |
| Redbud | 10500 | R | Mar-20 |
| Redbud | 10123 | D | Mar-20 |
| Redbud | 9998 | R | Apr-20 |
| Redbud | 11756 | D | Apr-20 |
| Redbud | 11010 | R | May-20 |
| Redbud | 12102 | D | May-20 |
| Redbud | 10687 | R | Jun-20 |
| Redbud | 11253 | D | Jun-20 |
| Redbud | 9998 | R | Jul-20 |
| Redbud | 11532 | D | Jul-20 |
| Redbud | 12002 | R | Aug-20 |
| Redbud | 12102 | D | Aug-20 |
| Redbud | 12000 | R | Sep-20 |
| Redbud | 10123 | D | Sep-20 |
| Redbud | 10002 | R | Oct-20 |
| Redbud | 9998 | D | Oct-20 |
| Redbud | 12001 | R | Nov-20 |
| Redbud | 11521 | D | Nov-20 |
| Redbud | 12000 | R | Dec-20 |
| Redbud | 13250 | D | Dec-20 |
Xx_LAMORAK_xX add following 3 measure and on line chart add measures to the pane as shown below
Packages Received = CALCULATE ( [Sum], Line[Receipt/Delivery] = "R" ) Packages Delivered = CALCULATE ( [Sum], Line[Receipt/Delivery] = "D" ) % Delivered = DIVIDE( [Packages Received] - [Packages Delivered], [Packages Delivered] )Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com
4 Replies
Xx_LAMORAK_xX are you looking for something like this. Would appreciate Kudos 🙂 if my solution helped.
Thats exactly what I am lookign for! How did you create that visual and what was the measure you used. Thanks so much that was quick!
Xx_LAMORAK_xX add following 3 measure and on line chart add measures to the pane as shown below
Packages Received = CALCULATE ( [Sum], Line[Receipt/Delivery] = "R" ) Packages Delivered = CALCULATE ( [Sum], Line[Receipt/Delivery] = "D" ) % Delivered = DIVIDE( [Packages Received] - [Packages Delivered], [Packages Delivered] )Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com
