topic Re: Apply Filter "is 1" on a Card Visual in DAX Commands and Tips

Apply Filter "is 1" on a Card Visual

Anonymous — Tue, 13 Dec 2022 14:53:05 GMT

Hi,

I've been watching this tutorial on how to make a preset value button panel for certain date ranges

https://www.youtube.com/watch?v=nocsNBF_NkE

The Sample File is here: https://github.com/MarkWilcock/lbag-online/tree/master/M%26G%20Results

I've succesfully implemented it, but I'm having trouble adding the Measure as a Filter in the Card Visuals

When I try to click on the options there to choose "is" it doesn't open up.

Is this a bug? Is there a way to implement this feature to cards as well?

Thank you!

Re: Apply Filter "is 1" on a Card Visual

latimeria — Tue, 13 Dec 2022 13:29:16 GMT

Hi Anonymous ,

Without sample, we can guess
Is 'Preset' value a number? My assumption it is a true/falsevalue, not a number. Wrap the formula with INT() to get a number.

Hope this help.

Re: Apply Filter "is 1" on a Card Visual

Anonymous — Tue, 13 Dec 2022 14:52:27 GMT

The Sample File is here: https://github.com/MarkWilcock/lbag-online/tree/master/M%26G%20Results

The Measure for Preset Value is:

Preset Value =

VAR presetCode = SELECTEDVALUE('Range'[Range])

VAR refdate = MAX('Combined Entity Employee'[Month])

VAR todayDate = TODAY()

VAR daysDiff = DATEDIFF(refdate, todayDate, DAY)

VAR result =

SWITCH(

presetCode,

"1M", IF(daysDiff < 31, 1),

"3M", IF(daysDiff < 92, 1),

"6M", IF(daysDiff < 183, 1),

"1Y", IF(daysDiff < 366, 1),

"YTD", IF(YEAR(refdate) = YEAR(todayDate) && refdate <= todayDate, 1),

"Max", 1,

RETURN result

So when I give a visual chart or table/matrix the filter "is 1" the range panel will trigger the last 3 months, 6 months, etc. as per the video tutorial: https://www.youtube.com/watch?v=nocsNBF_NkE

Re: Apply Filter "is 1" on a Card Visual

latimeria — Tue, 13 Dec 2022 15:15:39 GMT

Try changing the formula like this

"1M", IF(daysDiff < 31, 1,0), and so on.

"1M", IF(daysDiff < 31, 1) => if preset code= "1M", if daysdiff = 31 for example then preset value = false!!!

Re: Apply Filter "is 1" on a Card Visual

Anonymous — Tue, 13 Dec 2022 15:22:46 GMT

Thanks latimeria

It didn't work though 😞

Re: Apply Filter "is 1" on a Card Visual

latimeria — Tue, 13 Dec 2022 15:28:54 GMT

how many rows in preset value? blank row?

Re: Apply Filter "is 1" on a Card Visual

Anonymous — Wed, 14 Dec 2022 08:21:15 GMT

Hi Anonymous ,

Here I download your sample to have a test and I could reproduce your issue. You can see that I count [Date] in card visual and I try to add [Preset Value] in it as a visual level filter, it doesn't work.

As far as I know, measure need to be expand in other visuals like table/matrix or charts. Card visual will only return a single value, so measure filter may not support.

So I suggest you to create a new measure and add [Preset Value] =1 in filter field in your code.

Measure = CALCULATE(COUNT('M&G'[Date]),FILTER('M&G',[Preset Value] = 1))

Result is as below.

Best Regards,
Rico Zhou

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

Re: Apply Filter "is 1" on a Card Visual

Anonymous — Wed, 14 Dec 2022 08:40:18 GMT

Thank you Anonymous !!! That's brilliant !!! I'll try it out and follow-up as soon as possible.

Do you have any idea if I can sync the Preset Code panel with my Date Slicer?

I want to give my stakeholders the opportunity to use the preset codes and the date slicer as well (if they need to), but they seem to filter one another instead of syncing.

I've opened another thread here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Sync-Preset-Date-Value-with-a-Date-between-Slicer/m-p/2967421#M99085

Thanky a lot! This is the 2nd time you save me !!!