Requirement: Need to Compare with current year(2020) amount vs selected year by slicer(Prior Year )(2019,2018,..) in a column chart.
I am having the Year slicer with the values of 2020,2019...
For Ex: Current year : always show year 2020 amount it should ignore the slicer value
Prior Year : What ever the value selected by slicer Ex:if we select 2019 then will compare values with 2020 and 2019 and if we select 2018 then will compare with 2020 and 2018
Thanks In advance,
Go to Solution.
Hi @vasu538 ,
Create a measure like this and apply it to visual level filter.
Measure = IF(SELECTEDVALUE('Table'[year])=MAX(test1[year])||MAX(test1[year])=2020,1)
Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.