Forum Discussion

Grimfandango227's avatar
Grimfandango227
Frequent Visitor
2 years ago

Only show Y-Axis if Splicer selection activated

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. 

Custom visual
Line & Stacked Column
Slicer

1 Reply

  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    Solution Sage
    2 years ago

    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