Filter Option

[yuvanne_11]

Hi,

I want to create a measure and use that as a filter. So I am dealing with the inventory dashboard. I have columns such as >4 years, <4 years, < 3 years, < 2 years, and so on. These are in currency format. Now, I want to create a filter with these columns inside, like just the text. So the user can choose for example > 4 years in the filter and the graphs give the inventory information accordingly. Can this be done in Power BI? Looking for something as attached below.

Thanks.

[yuvanne_11]

Oh okay!

Got it. Thank you so much

[yuvanne_11]

But that calculated column would give the options in numbers, right? Instead I just want the text to be displayed

[jgeddes]

It would not have to be numbers, it could be text. Here is an example measure;

Date Group =

var _dateDiff =

DATEDIFF(TODAY(),dimDate[Date],YEAR)

Return

SWITCH(

    TRUE(),

    _dateDiff = 0, "Year 2022",

    AND(_dateDiff < 0, _dateDiff >= -1), "Year 2021",

    AND(_dateDiff < -1, _dateDiff >= -2), "Year 2020",

    AND(_dateDiff > 0, _dateDiff <= 1), "Year 2023",

    "Other Year"

)

This measure would produce a column that would show up in a filter like

[jgeddes · Accepted solution]

You cannot use a measure as a filter. What you could do is create a calculated column that evaluates the closing stock date and assigns it the closing stock value. That calculated column could then be used as a filter.