Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |