Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Problems creating calculated table from a slicer

Hello, I've been stuck with this issue for hours and I need help understanding why this solution isn't working.    What I want to solve is this:  I have a large table and based on a dropdown isol...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Yes. I've tried with SELECTEDVALUE('Years (slicer)'[Year]), INT(SELECTEDVALUE('Years (slicer)'[Year])) and CONVERT(SELECTEDVALUE('Years (slicer)'[Year]), INTEGER) but didn't work. Any light with this BI variable?

littlemojopuppy's avatar
littlemojopuppy
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous calculated tables and columns only recalculate when data is refreshed, not when slicers change.  What you're trying to do is not possible.  Sorry to be the bearer of bad news 😕

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks for your time. It seems that I will change something of this model. How can I handle this solution?

    • littlemojopuppy's avatar
      littlemojopuppy
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Anonymous no worries...I'm just trying to run out the clock at work.  What are you trying to do?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

         

        I want to do these things:

        - Select a Year and a Metric 

        - In a Line Chart display the metric selected with 3 curves: Present Year, Quota, and Last Year (see the image above).

        - Keep the Line colors when you change the metric or year, for example, red for Quota, blue for Present Year, and gray for Last Year.

         

        Thanks