topic Re: Power BI Cross Filter Between Visuals Issue in DAX Commands and Tips

Power BI Cross Filter Between Visuals Issue

abhiram342 — Thu, 29 Feb 2024 03:09:02 GMT

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

Re: Power BI Cross Filter Between Visuals Issue

Anonymous — Fri, 01 Mar 2024 01:42:40 GMT

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

Re: Power BI Cross Filter Between Visuals Issue

abhiram342 — Mon, 04 Mar 2024 04:37:27 GMT

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