Forum Discussion

benfrenkel's avatar
benfrenkel
Helper I
9 years ago

filtering chart or grid with dax

 

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 ??

 

 

General Comment

1 Reply

  • dearwatson's avatar
    dearwatson
    Continued Contributor
    9 years ago

    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.