Forum Discussion
Exclude Columns used from one visual (table) when cross filtering other visual (trend line chart)
shaikarshad29 , Small change in the formula is also required.
Refer to the attached file
shaikarshad29 , one of the options is to have two date tables and use different date tables on the axis on two visuals. Both date tables are joined with your fact
I am still seeing the same issue:
My two date tables relationship:
Table visual uses primary date table:
Chart visual uses secondary date table:
Still getting the same behavior withd ate filter applied:
Appreciate any further help
shaikarshad29 , Small change in the formula is also required.
Refer to the attached file
Thanks Amit, this worked. So basically anyone else looking for more details: To resolve this issue, you need two date columns which have a relationship as suggested above and then add "REMOVEFILTERS()" dax in your measure formulae. In my case I had two date columns one date was used in the table visual which cross filters and the other date column on x-axis of chart for which I don't want the filtering to propagate, and the measure used in y-axis has "REMOVEFILTERS()" applied on the date column used in table visual: