Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Hi @PBNikr
Try this, a slight variation on what you already had:
Choose Employee = IF ( CALCULATE ( ISFILTERED ( 'Employee'[Name] ); ALLSELECTED ( 'Employee'[Name] ) ); CALCULATE ( Table[% Value] ) )
HI @PBNikr,
Make use of it
Hi @PBNikr
Try this, a slight variation on what you already had:
Choose Employee = IF ( CALCULATE ( ISFILTERED ( 'Employee'[Name] ); ALLSELECTED ( 'Employee'[Name] ) ); CALCULATE ( Table[% Value] ) )
Thanks AIB for the post. What could I replace for the part in the blue text below:
Choose Employee = IF ( CALCULATE ( ISFILTERED ( 'Employee'[Name] ); ALLSELECTED ( 'Employee'[Name] ) ); CALCULATE ( Table[% Value] ) )
I have attempted your DAX on a similar situation with overwhelming linegraph (x-axis = year, y-axis = index score, legend = country names), but not sure what to replace for that piece (and the DAX won't work if I don't complete the requirements for 3 arguments). Have also used an INT(ISFILTERED(table[column])) function to attempt this filter and also doesn't work... I'm assuming because of my complication of the x-axis. Any insight? Happy to send a test file if necessary.
Yes, please share a test file.
You have to share the URL to the file hosted elsewhere: Dropbox, Onedrive... or just upload the file to a site like tinyupload.com (no sign-up required).
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
89 | |
86 | |
75 | |
69 | |
68 |
User | Count |
---|---|
220 | |
128 | |
117 | |
82 | |
77 |