2 Replies Latest reply on Nov 21, 2018 7:30 AM by Michael Ye

    Any way to exclude dimension members from quick filter actions?

    Mir Masud

      I have come across a small requirement where I have a waterfall chart consisting 5 bars (for 5 different dimension members coming from a group).

      Now on filtering with a specific date value, one of those bars are getting removed from the waterfall chart (this is happening because for that particular date there is no data for that dimension member - no transaction happened).

      Now, what I am trying to do is to show that dimension member's bar even if there is no data for it on that filtered date value (the bar still should show $0).

      Using LOD functions, we can exclude measures from being affected by a dimension filter. But is there any way we can exclude a dimension member to be affected from a different dimension filter?

       

      Thanks in advance!