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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

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