Forum Discussion
Q&A Visual Not Showing Upcoming Month Events — Only Current and Past Months Displayed
Hello Ashavorn_Code,
Thank you for reaching out to the Microsoft Fabric Forum Community.
I’ve reproduced your scenario in Power BI using a sample release calendar like yours. Initially, I observed the same behaviour queries as “Commit in July” didn’t return results even though the July event existed in the data.After investigating, I identified that this happens because the Q&A visual’s NLP engine may implicitly apply a filter on the date field (≤ TODAY()), hence ignoring future-dated entries.
Workaround Implemented:
To address this, I added a calculated column to the dataset:
IsFutureEvent = IF([Date] > TODAY(), "Future", "PastOrToday")This enables more explicit control over filtering in the Q&A visual. For your reference, I’m attaching the .pbix file.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
Community SupportHello Ashavorn_Code,
Thank you for reaching out to the Microsoft Fabric Forum Community.
I’ve reproduced your scenario in Power BI using a sample release calendar like yours. Initially, I observed the same behaviour queries as “Commit in July” didn’t return results even though the July event existed in the data.
After investigating, I identified that this happens because the Q&A visual’s NLP engine may implicitly apply a filter on the date field (≤ TODAY()), hence ignoring future-dated entries.
Workaround Implemented:
To address this, I added a calculated column to the dataset:
IsFutureEvent = IF([Date] > TODAY(), "Future", "PastOrToday")This enables more explicit control over filtering in the Q&A visual. For your reference, I’m attaching the .pbix file.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
- MFelix
Super User
Hi v-ssriganesh ,
Altough your logic is correct in terms of the filters, the column you added to the model doesn't make any difference, the main point is that you are changing the way you are making the question on the model and you are speciffically refering to July 2025 that is why you got the result not because of the addtional column.
- v-ssriganesh
Hello Ashavorn_Code,
I hope the information provided has been useful. Please let me know if you need further clarification or would like to continue the discussion.
If your question has been answered, please “Accept as Solution” and Give “Kudos” so others with similar issues can easily find the resolution.
Thank you.
