Power BI filter over 6 month and last 6 month

[mariag13011995]

I would like to create a button filter in power bi that would allow me to show the values ​​that have been active for more than 6 months and those that have been active for less than 6 months, I will explain an example:

Then in Power Bi have a filter like this (This filter is not created, I have only posted an image of how I would like it to appear, but I don't know how to create it):

So when I click on "last 6 month" in the matrix will appear:

And if I click on "over 6 month" the matrix will change the data for:

[v-zhangti · Accepted solution]

Hi, @mariag13011995 

You can try the following methods.

Column = IF(DATEDIFF([DATE],TODAY(),MONTH)<=6,"last 6 month","over 6 month")

Result:

Is this the result you expect?
DATEDIFF function (DAX) - DAX | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

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

[FreemanZ]

is period name a column?

[mariag13011995]

No, I do not know how to create that filter, so is just an image that reflect how I would like this filter looks like