Forum Discussion
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...
qqqqqwwwweeerrr
Solution Sage
Solution Sage
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.
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