Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Let visual be ignored by specific filter(s)

Hi all, We're running into a problem regarding filtering on a visual. The visual uses "Week" for the x axis, throughout the report we are using the filters "Week", "Month" and "Year" to filter visua...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

    Could you please try to add the field "week" of table "UNIT" into Filters pane instead of the field "WeekNr" of table "CALENDAR"?

    Best Regards

    Rena

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

Which table the field Amount is from? Please try to change the table CALENDAR in the formula to the table where the field amount is: 

CALCULATE ( SUM( [Amount] ) , ALL ( TABLENAME) )

Best Regards

Rena

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello Anonymous ,

     

    When I do that, the graph shows the total amount for every week. I get a horizontal line, which is not correct.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous ,

      Could you please provide the fields which applied to this column chart and some sample data(exclude sensitive data)? Please also provide the formula if applied any measure or calculated column.

      Best Regards

      Rena

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Of course, the bar chart is made out of two tables:

        - CALENDER (ISO based)

        - UNIT

         

        X axis: Year, Period, Week hierarchy

        Y axis: Amount of units transported

         

        The transport date field of the UNIT table is linked to the date field of the CALENDER table. I've added an example PBI file. The idea is that the table does filter with the week filter, but the graph will always show all weeks. Using slicers are not an option.

         

        Thanks!

         

        Example file