Forum Discussion

Dellis81's avatar
Dellis81
Post Prodigy
6 years ago
Solved

Interactive visuals should filter out zero values

Hello

 

I am needing help in filtering out zero values in an interactive visual.     If I select "purchased livestock" in the left visual, I only want the customers related to purchased livestock to show up in the right visual.

 

Within the "right" visual, I have attempted to filter out (at the visual level) for any value not 0, for the measure Amount.   The desired result for the "right sided" visual is all vendors with an Amount <>0.

 

 

Within hte left sided visual - I have 4 row levels within the matrix visual.  I am assuming whatever is done, will require these data elements?

 

I have also attempted to adjust the measure if zero, then blank.  See below.

Amount1 =
VAR calcAmount1 =
    SUMX (
        COASetup,
        [Amount (dbcr balance)] * COASetup[NormalBalance] * COASetup[Report Sign]
    )
RETURN
    IF ( calcAmount1 = 0, BLANK (), calcAmount1 )

 Please advise - surely there is a simple fix.   I am disappointed in the visual filter not working - or am I missing something?

 

thanks

  • Hi Dellis81 ,

     

    You should use the Edit interactions instead of the filter.

     

    When selecting values from a visual the other visual can responde in 3 different ways:

    • Filter - information only shows the values selected on the first chart (similar as using slicers)
    • Highlitgh - information is highligted (is what is by default can be changed)
    • None - don't interact

    Check the documentation for further explanation.

     

    Regards,

    MFelix

2 Replies

  • Hi Dellis81 ,

     

    You should use the Edit interactions instead of the filter.

     

    When selecting values from a visual the other visual can responde in 3 different ways:

    • Filter - information only shows the values selected on the first chart (similar as using slicers)
    • Highlitgh - information is highligted (is what is by default can be changed)
    • None - don't interact

    Check the documentation for further explanation.

     

    Regards,

    MFelix

    • Dellis81's avatar
      Dellis81
      Post Prodigy

      Thank you very much!  Yes, I was making this to hard and the video clarified so much.   I recall watching the same video several months ago, but with a little experience, the video makes more sense.   Appreciate your quick response!