Forum Discussion

wbcogswell26's avatar
wbcogswell26
Frequent Visitor
1 year ago
Solved

Power BI - Remove Field from Click Filter

Hello!    I've searched these forums over and over and can not find a solution to this issue;  I have two charts, one is a line chart from 2018-2022; the other is a bar graph by categoy for the la...
  • lbendlin's avatar
    1 year ago

    Create a calculated table that lists category sales filtered by 2022.  Keep that table disconnected and use it to feed the left visual. Then create a measure that senses the FILTERS of the category column on that table and filters the right visual accordingly.