topic Re: Card Visual to show nothing in DAX Commands and Tips

Card Visual to show nothing

rwong1 — Tue, 03 Oct 2023 17:20:23 GMT

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.

Re: Card Visual to show nothing

Anonymous — Thu, 05 Oct 2023 01:47:14 GMT

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.

Re: Card Visual to show nothing

rwong1 — Fri, 06 Oct 2023 03:05:46 GMT

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.

Re: Card Visual to show nothing

Dangar332 — Fri, 06 Oct 2023 04:28:49 GMT

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

Re: Card Visual to show nothing

Anonymous — Fri, 06 Oct 2023 05:59:17 GMT

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())

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.