Update charts with multiple tables

Question

Hi Guys,I have 2 sets of dataTable 1: Prior Year with category and monthTable 2 : Current Year with category and monthI want to be able to compare the two, so I create another table:Table 3:Column 1: CategoryColumn 2: CY&nbsp;$ (Using Calculate sum, all selected formula)&nbsp;&nbsp; to find the corresponding value on each category on table 1Column 3: PY $ (Using Calculate sum, all selected formula)&nbsp;&nbsp; to find the corresponding value on each category on table 2Column 4: Delta between CY $ and PY $I then create a relationship between Table 1, 2 and 3 using category (both sides)How come when I create the dashboard, whenever I filter on the month (from table 1 and 2), the delta (Column 4 on table 3) doesn't update automatically together with the month&nbsp;filters? Is there any workaround for this?

jthomson · Answer

It's possibly something to do with how your tables are related and information not passing through properly, although I'm not sure why you wouldn't take the approach of just merging your tables 1 and 2?

anonymous · Answer

Hi&nbsp;euniceylk,&nbsp;&gt;&gt;How come when I create the dashboard, whenever I filter on the month (from table 1 and 2), the delta (Column 4 on table 3) doesn't update automatically together with the month&nbsp;filters? Is there any workaround for this?Current power bi not support to create dynamic calculate column/table based on slicer or filter.&nbsp;Reference link:Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.&nbsp;For your scenario, you can try to write dynamic measure based on slicer to instead calculate table.&nbsp;Regards,Xiaoxin Sheng

Forum Discussion

Related content

Multiple Donut charts with conditions

Multiple line and clustered columns chart

App not updating

Small Multiples chart

Waterfall chart with multiple measures