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 ,

Please check the below screenshot:

Best Regards

Rena

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Whoops, I indeed forgot to insert the right data field. However, when I correct this I get the following. For me, it still doesn't work:

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

    It seems the filter for weeknum be put on report level filter, could you please just put it in page level filter? Then set the filter separately for other report pages one by one...

    Best Regards

    Rena

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello Anonymous 

       

      That does not make a difference. Is there maybe something wrong with the relationship between these tables? It's currently a many-to-one with filtering to both directions.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous ,

        Whether the filter field applied on page-lvel filter is from the field "Week" in table "Unit"? And the formula of measure "Amount_Unfiltered" as below:

        Amount_Unfiltered = CALCULATE(SUM(UNIT[Amount]),ALL('UNIT'))

        Best Regards

        Rena