Apply Filter "is 1" on a Card Visual

[Caesarul]

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!

[latimeria]

Hi @Caesarul ,

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.

[Caesarul]

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,

    0)

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

[Anonymous · Accepted solution]

Hi @Caesarul ,

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.

[Caesarul]

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 !!! 

[latimeria]

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!!!

[Caesarul]

Thanks @latimeria 

It didn't work though 😞 

[latimeria]

how many rows in preset value? blank row?