Forum Discussion

deannag's avatar
deannag
Helper I
3 years ago

How do I get a bar graph with two lines?

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!
 
Need Help
Tips and Tricks
Tutorial Requests

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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's avatar
      deannag
      Helper I
      3 years ago

      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