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.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[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