How to synchronize a slicer with a chart

[robak99]

Hello. I want the chart not to show me the values only from 2021. How can I get avoid this problem? This is my report :

This is my data:

This is measure 'example' : 

example = CALCULATE(

if(SUM(Tabela3[min])=blank(),0,SUM(Tabela3[min])),

FILTER(Tabela4,Tabela4[Id p]=1))

How can I correct this code?

[v-xiaoyan-msft]

Hi @robak99 ,

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!

Hope it helps,

Community Support Team _ Caitlyn

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

[AlexisOlson · Accepted solution]

I propose the following:

example = 
VAR SumMin = CALCULATE ( SUM ( Tabela3[min] ), FILTER ( Tabela4, Tabela4[Id p] = 1 ) )
RETURN
    IF ( ISBLANK ( SumMin ) && NOT ISEMPTY ( Tabela2 ), 0, SumMin )

The extra condition that Tablea2 is not empty only replaces blank with zero when it's within the range associated with the selected date.

[AlexisOlson]

You can Edit Interactions such that the slicer does not apply to the visual.

In particular, click on Edit Interactions under the Format pane, click on your Year slicer and then click the no impact icon located near the corner of the chart visual.

[robak99]

Sorry, I wrote it bad. I want values only from 2020 when I when i click on 2020 and only from 2021 when i click on 2021. I don't want the rest:

I want something like this but with values 0, not NULL (this measure doesn't work as expected):

[AlexisOlson]

Are you using Tablea2 or Tablea3 for your axis? I think Tablea2 is what you want.

[robak99]

I using Tabela2. I tried Tabela3 but it doesn't work either.

[AlexisOlson]

Hmm. What does Tablea1 look like? If it's just {{1,2020},{2,2021}}, then I don't understand why the extra [Id m] are showing up on the chart and I'd have to look at the .pbix to tell what's going on.