I need to display last 30 days bar chart

[RasDev1]

Hi members , I am new to power pi ,
I need to display the last 30 days in the graph,
I added a filter to last 30 days,its work good
but the problem is when i search a previous months (example may month)it should be blank .
how to rectify the issue?
see images

[uzuntasgokberk · Accepted solution]

Hello @RasDev1,

You can create a measure:
test=

VAR x_=

    CALCULATE(

        MAX('your table'[_Date]),

        REMOVEFILTERS('yourtable'[Date])

    )

RETURN

IF(

    SELECTEDVALUE('yourtable'[Date]) >= x_ -30,

    1,

    0)

And make it filter in filter pane as 1. İt is working sync with your filter.

Best Regards,
Gökberk Uzuntaş

LinkedIn: https://www.linkedin.com/in/g%C3%B6kberk-uzunta%C5%9F-b43906198/

Medium: https://medium.com/@uzuntasgokberk

İf this post helps, then please consider Accept it as solution and kudos to help the other members find it more quickly.

[Kedar_Pande]

Create a Measure

ShowGraph = 
IF(
MAX('YourDateTable'[Date]) < TODAY() - 30,
0, // or BLANK()
1
)

Add the ShowGraph measure to your graph's filters area and set the filter to only show when ShowGraph equals 1.

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[RasDev1]

Same issue is repeat