Forum Discussion

hayleyR's avatar
hayleyR
New Member
9 years ago
Solved

Items exceeding date in column x

Hi, 

 

I am trying to display only items that have exceeded the date in my 'Due Date' column, ie overdue items.

If anyone has any advice on how to acheive this for one graph whilst not affecting the rest, I would really appreciate it.

 

Thanks!

Hayley

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi hayleyR,

     

    You can create a calculated column which return results based on whether the date is exceeding the due date.

     

    Exceed = IF('Table3'[Date]>'Table3'[Due Date],"Exceed",BLANK())

     

    Then drag this calculated column to the Visul Level Filter pane of that specific visual, check the value "Exceed" to only filter that specific visual without affecting any other visuals. You can check attached .pbix file. Regarding filter pane, you can take a look at this article: Add a filter to a Power BI report (in Editing view). 

     

    Best Regards,
    Qiuyun Yu

1 Reply

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Hi hayleyR,

     

    You can create a calculated column which return results based on whether the date is exceeding the due date.

     

    Exceed = IF('Table3'[Date]>'Table3'[Due Date],"Exceed",BLANK())

     

    Then drag this calculated column to the Visul Level Filter pane of that specific visual, check the value "Exceed" to only filter that specific visual without affecting any other visuals. You can check attached .pbix file. Regarding filter pane, you can take a look at this article: Add a filter to a Power BI report (in Editing view). 

     

    Best Regards,
    Qiuyun Yu