Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Malekz
Frequent Visitor

Show Blank when nothing is selected in the slicers

Hello Community,

 

I have this view of my report : 

Malekz_0-1700042638392.png

 

I want to show no data when nothing is selected on the slicers

I tried with creating a measure

IsFiltered = CALCULATE ( IF ( ISFILTERED ( master[programnumber])||ISFILTERED ( master[programname])||ISFILTERED ( master[mastercontractnumber])||ISFILTERED ( master[period_begin_date])||ISFILTERED ( master[period_ending_date])||ISFILTERED ( master[int_employee_id]), 1, 0 ),ALLSELECTED(master)
 
It works for the first visual which is multicard when I add it and filter on 1 
But not the second one since it's not including this fields.
 
PS: the second visual is not a table, it's different cards to show calculation
 
Hope you help me
 
Thanks

 

1 ACCEPTED SOLUTION

try to do it like in my file, play with the slide and see

View solution in original post

5 REPLIES 5
Ahmedx
Super User
Super User

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

)
Malekz
Frequent Visitor

thank your for your answer @Ahmedx . The issue that's I don't know why but I can't configure the filter : 

Malekz_0-1700052028640.png

 

It's grey

 

show the measure , what you wrote.

Malekz
Frequent Visitor

The same you sent : 

Malekz_0-1700052419985.png

 

try to do it like in my file, play with the slide and see

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.