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 ( C...
"Help"
Cross-Filtering
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