The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Good morning Power BI community,
I have an issue with last 30 days relative date filter.
I have a simple column chart that shows BD avg in the last 30 days.
Master Calendar - Date - X axis
Receipt - BD Avg - Y axis
Relationships: Master Calendar 1:* Receipt.
BD Avg is a measure
Everything was working properly till last week, and now I cannot filter the date by last 30 days as the chart is blank then. When I try to filter by last 3 months it is ok though.
I haven't change anything in the relationship or made any other changes.
This is the original visual:
Here is what I can see now:
And here is now without any date filter, looks ok till I want to filter it.
I have spent lots of time trying to fix it by google search of similar issues, but still don't have the answer.
I would appreaciate any piece of advice on it.
Reagrds,
Agata
@AgataJ , first of all, check do you have data in fact/s for the last 30 days. In case you are using date table, does date table has dates for last 30 days
Hi @amitchandak , thank you for your time and reply.
I have just checked both tables, Master Calendar has dates in the last 30 days, Receipt table has orders in the last 30 days as well.
Kind regards,
Agata
@AgataJ
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi @amitchandak
I started to prepare the file to send it here, I was removing slicers and it turned out all data showed back when I removed one of the slicers. So i think the issue is here, now I need to review it.
Thank you very much for your time, without your question about sending data I would not get to it 🙂
A.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
107 | |
76 | |
61 |
User | Count |
---|---|
276 | |
129 | |
122 | |
100 | |
88 |