Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Hi @v-shex-msft - 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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |