Forum Discussion

yuvanne_11's avatar
yuvanne_11
Frequent Visitor
3 years ago
Solved

Filter Option

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.

 

Need Help
  • jgeddes's avatar
    jgeddes
    3 years ago

    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.

4 Replies

  • jgeddes's avatar
    jgeddes
    Super User
    3 years ago

    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.

  • yuvanne_11's avatar
    yuvanne_11
    Frequent Visitor
    3 years ago

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

    • jgeddes's avatar
      jgeddes
      Super User
      3 years ago

      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