Forum Discussion
visual value is not syncing with other visuals
in my report page, one of the visual's value is not syncing when selecting another visual. however, remaing visuals are syncing at the same time.
this is a card visual and using a calculated column. i have already checked through Format-Edit Interaction and no issue there.
please suggest the solution
1 Reply
v-lili6-msftCommunity Support
hi, Anonymous
First, you should know that
1. Calculation column/table not support dynamic changed based on filter or slicer.
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.here is reference:
https://community.powerbi.com/t5/Desktop/Different-between-calculated-column-and-measure-Using-SUM/t...
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Second, If the data in different table, please check if they have the relationship between them and the cross filter direction is "both"
Best Regards,
Lin