Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to synchronize a slicer with a chart

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?

Need Help
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    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.

7 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    5 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    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's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    5 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        AlexisOlson
        Icon for Super User rankSuper User
        5 years ago

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