Filter a visual to last day available in the table

[Karthik12]

Hi all,

I have a table with production data. I have designed my power bi report to show "live production" i,e today current production.

and also yesterday production status in another page of the report.

Problem is when we apply filter-> relative date -> last 1 days, yesterday production sheet shows all visuals as "blank" when if there is no production yesterday (No production planned by our production planner).

In that case, our users want to show Last production day (yesterday = last production day).

In my data table also non production doesn't appear.

So, no need to find working day or non working day. If date exists in the table it is working day otherwise it was not working day.

I have attached my sample table herewith. Where my production completed 10th Feb 2023 itself. 

Now I would like to show this 10th Feb 2023 as last producion day

https://vontier-my.sharepoint.com/:u:/g/personal/karthikeyan_palanisamy_gilbarco_com/EQnKcjnToQ5Jrk9...

Can anybody support?

[amitchandak · Accepted solution]

@Karthik12 , I doubt there is greate option as of now. you have to create a new column in date table and use that as filter. Like max date in below column. I saw update on Linkedin some default feature is coming in

Date Type = SWITCH(TRUE(),'Date'[Date]=max(fact[date]),"Max Date"
,'Date'[Date]&"")

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA