Forum Discussion

mshamsiev1234's avatar
mshamsiev1234
Regular Visitor
1 year ago
Solved

Month Filter Displayed As Text

Hey community!   I am looking to create a text box or card based visual that displays all selected filters for our end users. I have managed to do so with the standard filters (though it only seems...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi mshamsiev1234 

    why not get the min and max months selected instead?

    MinMaxMonths = 
VAR MinMonth = FORMAT(MIN('Calendar'[Month]), "mmm-yy")
VAR MaxMonth = FORMAT(MAX('Calendar'[Month]), "mmm-yy")
RETURN MinMonth & ">" & MaxMonth

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi mshamsiev1234 ,

 

Thank you for reaching out to our community.

I see that rajendraongole1 and danextian have provided great solutions. Did their replies help you?

If so, please accept the reply as a solution. This will make it easier for the future people to find the answer quickly.

If not, please provide a more detailed description, preferably some virtual sample data, and the expected results.

 

Best Regards,

Stephen Tao

 

mshamsiev1234's avatar
mshamsiev1234
Regular Visitor
1 year ago

Hey Stephen thanks for the message 🙂 All great solutions. In this case, I have used danextians solution which worked a treat. Thanks again to everyone here, much appreciated!