Forum Discussion

SingSong's avatar
SingSong
Frequent Visitor
6 years ago

Filter and AllExcept

Hi, I am using a tabular model with measures to actual and plan as well as the variance. I use a Date table to display in a line chart the progress throughout this year by month. I also use a table...
SingSong's avatar
SingSong
Frequent Visitor
6 years ago

MartynRamsden  Thanks for the reply, unfortunately this is a solution I have already tried but tried again in the hope I had done something wrong. when implementing this solution the value for Current Year becomes the same for all months and it has no impact to the problem of the chart data being filtered to a single month when clicking on the table. I don't want to remove the interaction between the table and the chart because I do want clicking on the table to filter the chart to the the selected location.

 

thanks

D

MartynRamsden's avatar
MartynRamsden
Icon for Solution Sage rankSolution Sage
6 years ago
Hi SingSong

Are you able to share a copy of your pbix? Be sure to remove any sensitive data before you do.

Best regards,
Martyn
  • SingSong's avatar
    SingSong
    Frequent Visitor
    6 years ago

    MartynRamsden unfortnately not, I am using an SSAS model and the measures are written in there so not visible in pbix. I will take some time later to duplicate using excel or something as I would really like to get this issue resolved.

     

    Thanks

    D