Forum Discussion

abhiram342's avatar
abhiram342
Microsoft Employee
2 years ago

Power BI Cross Filter Between Visuals Issue

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

"Help"
Cross-Filtering

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      abhiram342
      Microsoft Employee
      2 years ago

      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