Q&A Visual Not Showing Upcoming Month Events — Only Current and Past Months showing

[Rakesh_ashavron]

Hi All,

I'm currently using the basic Q&A visual in Power BI to allow users to query release calendar events using natural language.

Attaching the structure of data:

So, when i ask questins like ""commit in june", "Can you please let me know the commit date in May?" - the correct date / result shows. Similarly, with current and past months it works fine.

But when I ask: “Commit in July” (or any upcoming month), it returns no results — even though the July events are present in the data and verified.

Still, the Q&A visual seems to only pick data from past or current months, and fails to recognize valid future month entries when queried by name.

Is there a known limitation or workaround to make the Q&A visual pick up future-dated records using month names? or am I missing something?

Adding the image for correct results:

Adding image for not showing results:

Also, I have found something, when I have a typo in month name for upcoming or future months it shows correct results:

Please help me to fix this.

Thanks 

[Ashavorn_Code]

Hi All,

I'm currently using the basic Q&A visual in Power BI to allow users to query release calendar events using natural language.

Attaching the structure of data:

So, when i ask questins like ""commit in june", "Can you please let me know the commit date in May?" - the correct date / result shows. Similarly, with current and past months it works fine.

But when I ask: “Commit in July” (or any upcoming month), it returns no results — even though the July events are present in the data and verified.

Still, the Q&A visual seems to only pick data from past or current months, and fails to recognize valid future month entries when queried by name.

Is there a known limitation or workaround to make the Q&A visual pick up future-dated records using month names? or am I missing something?

Adding the image for correct results:

Adding image for not showing results:

Also, I have found something, when I have a typo in month name for upcoming or future months it shows correct results:

Please help me to fix this.

Thanks in advance

[v-achippa]

Hi @Rakesh_ashavron,

Thank you for reaching out to Microsoft Fabric Community.

The issue here is because power bi Q&A applies implicit time based filtering logic based on today’s date. So it does not shows the future months results, it’s a known limitation.

When there is a typo in your query, it bypasses the semantic date logic and it will do a direct text based match, that is why the results show up.

So to ensure all the records, including the future months to show, I recommend to use the text columns, not derived from a date hierarchy. This allows Q&A to match values directly without applying time-based filters.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @Rakesh_ashavron,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
If my response resolved your issue, please mark it as "Accept as solution" and give kudos if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @Rakesh_ashavron,

We wanted to kindly follow up to check if the solution I have provided for the issue worked? 
If my response resolved your issue, please mark it as "Accept as solution" and give kudos if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @Rakesh_ashavron,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked?
If my response resolved your issue, please mark it as "Accept as solution" and give kudos if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa