Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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:
Check the documentation for further explanation.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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:
Check the documentation for further explanation.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank 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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |