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

Hi Anonymous ,

 

You could create a measure like below.

measure =
var sales_year = selectedvalue('Prep_Sales (2)'[Year])
var CurrentYear = SELECTEDVALUE('Years (slicer)'[Year])

return
IF( sales_year = CurrentYear || sales_year = CurrentYear-1,1,0)
Add this measure to visual filter set value = 1.

 

Best Regards,

Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I took it. But I can't maintain the colors because the category is on the legend.

So I have to get deep into this because I need some time calculations and Dax patterns to improve the design, and I think it is the right way to do this.

Thank you 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    "But I can't maintain the colors because the category is on the legend."

    You can set data color manually.

     

    Best Regards,

    Jay