I have a report where employees are selected from a slicer and a line appears in the line chart for each employee. However, when no employees are selected (by default) I have this crazy line chart that shows all employees in the same chart:
See image here: Crazy line chart
I have tried to work with some DAX to blank out the values if no filter values are selected but with no luck:
Choose Employee = IF( ISFILTERED('Employee'[Name]); CALCULATE(Table[% Value]); BLANK() )
The code above doesn't really do anything. Any idea on how I can get this to work?
Solved! Go to Solution.