Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Compare with current year with selected year by slicer

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

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

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)

V-lianl-msft_0-1607308768853.png

Sample .pbix

 

Best Regards,
Liang
If 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

1 REPLY 1
V-lianl-msft
Community Support
Community Support

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)

V-lianl-msft_0-1607308768853.png

Sample .pbix

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.