Forum Discussion

euniceylk's avatar
euniceylk
New Member
8 years ago

Update charts with multiple tables

Hi Guys, I have 2 sets of data Table 1: Prior Year with category and month Table 2 : Current Year with category and month I want to be able to compare the two, so I create another table: Tab...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi euniceylk,

 

>>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 filters? Is there any workaround for this?

Current power bi not support to create dynamic calculate column/table based on slicer or filter. 

Reference link:

Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.

 

For your scenario, you can try to write dynamic measure based on slicer to instead calculate table.

 

Regards,

Xiaoxin Sheng