filtering chart or grid with dax

[benfrenkel]

how to filter chart or grid with dax exp ?

is not an option in advance filtring of a page or report !!

for example last 6 weeks on sanday only   >> on axis chart or filtring  grid rows ??

[dearwatson]

Hi Ben,

Yeah there's no expression based filtering right now.. dont get me started on being able to filter by "This Week" or as you put it "In the last 6 Weeks" which has long been a shortcoming of Power BI.

The best way around this right now is to create a calculated column based on the expression e.g. create a column 

"Is in last 6 weeks on a Sunday" = IF(Table[Date]>DATEDIFF(TODAY(),-6,WEEK)&&(Table[DayName]="Sunday", TRUE(),FALSE())

(I didn't check this DAX syntax so apologies if there is mistakes, just an example)

Then I filter the page or report based on that column... its a crude way to do it but the only solution right now.