Values should not change based on the slicer in measure

[Anonymous]

Hi,

I have created a measure where it should not chnage based on the year selected in the slicer.

What ever year I select my measure should not change. 

Which ever year I select I should see line graph, where yu dont see when I have selected year 2021.

This is my measure: 

thanks in advance !

[Idrissshatila]

Hello,

This article will solve your problem https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p...

you will click on the slicer and then go to the format section in the header then edit interactions and block the one on the grapth you want.

If I answered your question, please mark my post as solution, Appreciate your Kudos👍

Follow me on Linkedin

[Anonymous]

@Idrissshatila  Thanks for your response 

I dont want the entier visual to stop interaction just the line needs to be stoped.

I am using cluster line graph.

Thanks !

[amitchandak]

@Anonymous , for that you need a year slicer on an independent year table and in that case you need use that as a filter in bat visual

//Year1  is independent Date table

calculate(Sum(Table[Value]), filter(Table, Table[Year] in values(Year1[Year]) ) )

no need to use this filter in line measure

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

[Anonymous]

@amitchandak 

if I create an Independent table how will my column values change ?

This below image is when 2022 is selected

this visual when 2021 is selected I am not  seeing the line.

I should see same values in line accross any year selecte from slicer only columns values should change as per the slicer.