Column chart- Show information/columns from current month and on

[c-iakovidou]

Hello all! I have this visual and I want it to show information from the current date we are in and then show the rest of the date. 

I wonder if there is another way besides excluding the columns I don't wish to see. 

Thank you in advance 🙂 

[amitchandak]

@c-iakovidou , You can use a visual level filter , Adavce filter on or after .

Relative date slicer

Or create column like this in date table and use that

flag =

If([Date] >= Today() , "On After" , "Before")

Use this as filter

[c-iakovidou]

Thank you so much for your answer! 

Can you share some more information about visual level filter ?

[amitchandak]

@c-iakovidou , refer if this can help

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter

In date you should get relative option