1 Reply Latest reply: Dec 13, 2016 8:15 AM by Gysbert Wassenaar RSS

    Filtering data in a dimension and in associate charts

    Christian Cutruneo


      I have a probem with filtering dataset of a dimension.


      I have a chart with 1 domension (Dim1) e 1 Measure (Mes1).

      I want to select only Dim1 that have Dim2="Physical" (The Dim2 can have value "Physical" or "Financial").


      In measure of the chart I have type this expression SUM({<Dim2={"Physical"}>}[Mes1]).


      The problem is that I see in the chart also the element for Dim2="Financial" (with value = 0).


      What can I do for remove this elements from the chart?