Only show Y-Axis if Splicer selection activated

[Grimfandango227]

Hello, 

I am wondering if there is a way to only show a Y-Axis line on a line and stacked column chart if a Slicer filter is activated. Screenshots below ↓↓

1. Is the chart when nothing in my slicer is selected (This is where I would like the Y-axis line to not appear)

2. Chart when Bin is selected on slicer (where I would like the Y-axis to then show up)

Any help would be greatly appreciated. 

Thanks!

Jeremy B. 

[qqqqqwwwweeerrr]

Hi @Grimfandango227 

this can be created by using two measure 

1. Create the measure for column using for line chart here is my example:

sum_gross_sales = SUM(financials[Gross Sales]) i am using this in y line chart
2. 

Amount Filtered =

IF ( ISFILTERED(financials[Product]), [sum_gross_sales],BLANK() ) use this in you line and stack bar chart

 here product is in your case is bin code

here is my outout: Nothing is selected line does not populate 

now if i select any thing from product: it works for single and multiple select

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

Regards