Q&A multiple date columns cause wrong date filter

[__ION__]

I currently working on a Q&A visual, but my table schema has multiple date columns (i have set Synonyms for them as class start date and class end date). The visual purpose is to help the user export table with more detail on the subject. 

The first problem is some time when user query 3 or more columns then the date filter will be misinterpreted (from ... to ... -> or, after ... -> in ...)

the second problem is when user query 3 or more column and both date columns in same table then the filter get mix up (show A, B, C, class end date, class start date, where class start date from 2022 to 2024). the Preview show that the date column use in filter get mix up, from "class start date" to "class end date", the filter "from ... to ..." become " ... or ...  

-> if i query only one date column and filter that one then it show right answer

-> if i query only one date column and filter the other then it show right answer
-> if i query both date column and filter the "class start date" then it filter the "class end date" (which is wrong)
-> if i query both date column and filter the "class end date" then it filter the "class end date" (which is right)
This may be due to the "class end date" appear first before the "class start date" in the synonyms list.

Is there any promt or setting in Q&A that i can use to help the AI distinct these two columns when use to filter in query?

[Anonymous]

Hi @__ION__ ,

Could you please post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further.

Best regards,

Lucy Chen

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