Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Team,
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,
Sid
Solved! Go to Solution.
Hi @Anonymous ,
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,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
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,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |