Create a Card that hides or shows values depending on the filter selection

[DanZloo]

Hi!

I would like to create a card that is dependent of a filter selection.

So, i am using conditional formating to solve this issue. I have a date visual that looks like this:

Date Visual v2 = IF(ISFILTERED('MTD/QTD/YTD Selection_v2'),"MTD "&MAX('MTD/QTD/YTD Selection_v2'[YEAR/MONTH]),(" "))

This works fine. Although when i am not selecting MTD or PMTD i want the text to be white or blank and therfore i created this measure to conditional format with:

Make Transparent Measure = IF(SELECTEDVALUE('MTD/QTD/YTD Selection_v2'[Selection]) = "MTD" && "PMTD", "#000000",

IF(SELECTEDVALUE('MTD/QTD/YTD Selection_v2'[Selection]) = "MTD" || "PMTD", "#000000","#FFFFFF" ))

with the above mentioned measure i get an error:
"Cannot convert value 'PMTD' of time text to type True/False" and i guess that is because i have 2 values instead of one.

Is there a way to bypass this or use another dax-format to get the expected result?

Kind Regards
D.Z

[v-rongtiep-msft · Accepted solution]

Hi @DanZloo ,

Please have a try.

Date Visual v2 =
IF (
    SELECTEDVALUE ( 'MTD/QTD/YTD Selection_v2' ) <> BLANK (),
    "MTD " & MAX ( 'MTD/QTD/YTD Selection_v2'[YEAR/MONTH] ),
    ( " " )
)

If it does not help, please provide more details with your desired output and pbix file without  priavcy information.

Best Regards

Community Support Team _ Polly

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

[DanZloo]

A similar solution to this is what i am after:

IF (

SELECTEDVALUE ( 'MTD/QTD/YTD Selection_v2'[Selection] ) = "MTD" && "PMTD" ,

"MTD " & MAX ( 'MTD/QTD/YTD Selection_v2'[YEAR/MONTH] ),

(" ")

)
Becuse that calculation gives me an error.
"Cannot convert 'PMTD' of type Text to type True/False

[DanZloo]

Hi @v-rongtiep-msft amd thank you for your answer!

Unfortunately that is not quite what i am after. That works fine if i have one value!

But what if i filter MTD & PMTD then the card will become blank