Power BI Cross Filter Between Visuals Issue

[abhiram342]

Hi all - We have report created based on Direct Query using Azure Data Explorer as source. We have column called Duration which is computed in kusto i..e difference between StartTime - Finishtime ( Consider today's time in case of blank). I see the cross filter is not working once the minute passes ( Duration Column includes days hours minutes). Is there workaround to exclude the Duration Column in Cross Filtering.

Also, When cross filteting happens, Is there way to force the filter to work on key column instead of all columns i..e Included in below pictue has all the columns.

Cross Filter not works after minute passes:

Note: DateDiff function is not supported in Direct Query mode for Azure Data Explorer.

Data:

Model:

After Removing Duration Column , Cross Filter works fine

Thanks,

Abhriam

[Anonymous]

HI @abhiram342,

So you meant this column value will dynamic change based on two datetime fields, right?

If that is the case, I think they should not be suitable to work as relationship keys, I'd like to suggest you use other static value field to create relationships. (for example: the category field id)

Regards,

Xiaoxin Sheng

[abhiram342]

Hi @Anonymous - Thank you for the reply! I was able to find solution for above scenario. 

Note: Relationship is based on EventId column not on TimeStamp column

Thanks,

Abhiram