How do I get a bar graph with two lines?

[deannag]

Hi,

I have a few questions:

First, is there no bar graph that can have two lines plotted on it? Also, I was able to sort the x value descending on other visuals, but not for the line and clustered column chart. I'm trying to plot ticket prices/sales by days out from the game, and this is what I want to replicate from Excel:

Daily volume being quantity of tickets sold, cumulative ATP (avg ticket price), and then sell-through being the quantity sold/total ticket quantity. It should be straightforward, but why does it seem like Power Bi makes things more complicated? This is what I have on Power Bi:

(not filtered for individual team)

Here are my columns/measures:

Days Out = DATEDIFF(tablename[sale_date_local], tablename[event_date], DAY)

Quantity Sold = CALCULATE(count(tablename[barcode]), FILTER('tablename', tablename[unit_price] > 0), FILTER(tablename, NOT(ISBLANK(tablename[sale_date]))))

ATP = CALCULATE(AVERAGE(tablename[unit_price]), FILTER(tablename, not(isblank(tablename[unit_price]))))

Overall Sell-Through draft = 

CALCULATE([Quantity Sold] / ([Total Ticket Quantity]))

Could anyone help nme out with my sell-through percentage and ATP? It should be a smoother line. I also need to sort days out descending, 30-0 and not 0-30. Also, whenever I try to use two lines on this visual (line and clustered column chart) one of the lines is really weird.

Thanks!

[amitchandak]

@deannag , I power bi the lines can not use both axes. This means both lines would be there on Y-axis or secondary y-axis. 

For smooth line, there is an option in the latest release

[deannag]

How could I sort my days out descending? Normally it's the ... in the top right of the visual, but not with this combo chart for some reason