Dynamic Bar and Line chart

[MrNoob]

I am looking to add a dynamic bar and line chart to a report.  It works now however, when bookings is selected it displays the sales discount line.  I am looking for if bookings are selected only display the bars.  If sales are selected show both Sales and the line 

Bare and Line

Thank you in advance for the help

Selected Meassure = 
SWITCH( 
    VALUES(zSlicer[Column1]),

    "Sales",'[Sales],

    "Bookings",[Bookings]
)

[v-robertq-msft · Accepted solution]

Hi, @MrNoob 

According to your requirement, you can try this measure to replace [Sales] in line chart:

Measure =

SWITCH(SELECTEDVALUE('ZSilcer'[Column1]),

"Bookings",BLANK(),

"Sales",MAX('Sales'[Sales]))

You can also download my pbix file here:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/xiaoxin_qiuyunus_onmicrosoft_com/Efg-WCMM5CFOmbXuT...

And you can get what you want, like this:

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MrNoob]

I actullay just tried this before checking this message and it worked :).  Thank you!!!