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.
Hello Community,
I have this view of my report :
I want to show no data when nothing is selected on the slicers
I tried with creating a measure
Solved! Go to Solution.
try to do it like in my file, play with the slide and see
pls try this
IsFiltered =
IF ( (
INT (ISFILTERED ( master[programnumber] )) +
INT (ISFILTERED ( master[programname] ))+
INT ( ISFILTERED ( master[mastercontractnumber] ))+
INT (ISFILTERED ( master[period_begin_date] ))+
INT ( ISFILTERED ( master[period_ending_date] ))+
INT (ISFILTERED ( master[int_employee_id] ))
) > 0 ,
1,
0
)
thank your for your answer @Ahmedx . The issue that's I don't know why but I can't configure the filter :
It's grey
show the measure , what you wrote.
The same you sent :
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 |
---|---|
87 | |
86 | |
68 | |
65 | |
63 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |