topic Re: To show Blank in card visual until a value in filter is selected in DAX Commands and Tips

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

Praj — Mon, 05 Jun 2023 14:40:58 GMT

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.

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

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

BITomS — Mon, 05 Jun 2023 16:30:34 GMT

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!

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

Praj — Mon, 05 Jun 2023 16:37:34 GMT

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 😞

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

BITomS — Tue, 06 Jun 2023 09:00:30 GMT

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

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

Praj — Tue, 06 Jun 2023 09:11:29 GMT

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

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

Praj — Tue, 06 Jun 2023 09:30:06 GMT

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

Cheers,

Praj