Forum Discussion
KrisKolady
1 year agoFrequent Visitor
Dynamic time interval for one visual
I have multiple visuals on a page all being filtered by a Date[Year] slicer. I'd like to have one of the visuals show three years data which dynamically shifts based on the Year selected. For exa...
Anonymous
1 year agoNot applicable
HI KrisKolady,
In fact, the relationship and the filter effects from related fields have higher priority than measure filters.
Their effect will be enabled on the virtual table that visual and measure used before the customize measure filter applied and you can't use measure expression and dax funcitons to ignore these effects.
Notice: the data level of power bi(from parent to child level)
Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)
Regards,
Xiaoxin Sheng