Reply
Praj
Helper I
Helper I

To show Blank in card visual until a value in filter is selected

Hey Everyone,

 

I have created a card visual which shows the details such as contract start date, Upcoming activities, Last Activity etc as shown below.

Praj_0-1685975810205.png

 

I have two filters, 1st filter to select company and second filter to select the members in the comapny. Whenever our user selects the 1st filter(i,e just the comapny) all the above cards should be blank or invisible. If the user selects the 2nd filter(i,e the member ) then the card visual need to show the details of that specific member.  Currently, If the user selects any comapny from the 1st filter, the cards will show the details of the 1st member of the company based on the alphabetical order

 

Is there any way how I can achieve this. ? Any solution/approach is highly appreciated. 

 

Cheer,

Praj

1 ACCEPTED SOLUTION
BITomS
Continued Contributor
Continued Contributor

Hi @Praj ,

 

I think this can be done with new measures for each card visual:

 

Measure = IF( ISFILTERED('1st filter') && ISFILTERED('2nd filter') , [original measure you want to show] , blank() )

 

Hope that helps!

View solution in original post

5 REPLIES 5
Praj
Helper I
Helper I

Hi @BITomS ,

 

Thanks for your response. I did try this before, but I am trying to show the values from the calculated columns in the card visuals and not from the measure 😞 

BITomS
Continued Contributor
Continued Contributor

Is there anything stopping you creating a measure for each card visual?

Thanks for your response @BITomS , The values which I am showing in the card visuals are string type and cominmg directly from the raw data columns. I am bit new to Power BI, am not sure on how to create a measure for string type columns. Is that possible ?

 

Cheers,

PRaj

Hey, @BITomS , I think I figured a way from your approach. seems like it works. Thanks for that!

 

Cheers,

Praj

BITomS
Continued Contributor
Continued Contributor

Hi @Praj ,

 

I think this can be done with new measures for each card visual:

 

Measure = IF( ISFILTERED('1st filter') && ISFILTERED('2nd filter') , [original measure you want to show] , blank() )

 

Hope that helps!

avatar user

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)