Forum Discussion
Solved
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 compari...
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
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
This worked like a charm, why didn't I think to parse it out into three seperate measures. That would have made it super simple!