Card Visual to show nothing

[rwong1]

Hi,

I'm trying to get a card visual that contains the growth data to not show anything if NO month is selected.  I tried alot of things and it still didn't work.  I just want to have my card visual show nothing or blank or NA if the month slicer is not selected.  If the year and quarter slicer is selected I want the card visual to show the revenue growth value.  I tried:

IF(HASONEVALUE('Date'[Month]),BLANK(), DIVIDE(([Actual Revenue]-[Actual Sales QTD Previous]),[Actual Sales QTD Previous]))

IF(SELECTEDVALUE('Date'[Month]),BLANK(), DIVIDE(([Actual Revenue]-[Actual Sales QTD Previous]),[Actual Sales QTD Previous]))

Nothing is working.  Please advise if you have any ideas.

Thanks.

[Anonymous · Accepted solution]

Hi @rwong1 ,

Update the measure.

revenue growth value =DIVIDE(([Actual Revenue]-[Actual Sales QTD Previous]),[Actual Sales QTD Previous])

If you want to select the year slicer or select the quarter slicer or select the month slicer to display the revenue growth value:

Measure = SWITCH(TRUE(),
ISFILTERED('Date'[Year])=TRUE(),[revenue growth value],
ISFILTERED('Date'[QUARTER])=TRUE(),[revenue growth value],
ISFILTERED('Date'[Month])=TRUE(),[revenue growth value])

If you want to select both the year and quarter slicers to display the revenue growth value:

Measure 2 = IF(ISFILTERED('Date'[Year])=TRUE() && ISFILTERED('Date'[QUARTER])=TRUE() ,[revenue growth value],BLANK())

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Anonymous]

Hi @rwong1 ,

According to your description, here are my steps you can follow as a solution.

(1)  We can create a measure. 

Measure = IF(ISFILTERED('Date'[Month])=FALSE(),BLANK(),DIVIDE(([Actual Revenue]-[Actual Sales QTD Previous]),[Actual Sales QTD Previous]))

or:

Measure = IF(SELECTEDVALUE('Date'[Month])=BLANK(),BLANK(), DIVIDE(([Actual Revenue]-[Actual Sales QTD Previous]),[Actual Sales QTD Previous]))

(2) Then the result is as follows.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[rwong1]

Hi,

It didn't work.  It showed BLANK no matter what the situation is even if I had quarter and year selected.  I'll try to get you over a pbix file.

[Dangar332]

Hi, @rwong1 

Try below one 

 IF(ISFILTERED('Date'[Month])=FALSE(),if(isfiltered('date'[year] )|| isfiltered'(date'[quarter]),DIVIDE(([Actual Revenue]-[Actual Sales QTD Previous]),[Actual Sales QTD Previous]),blank()),blank())

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly