Forum Discussion
Let visual be ignored by specific filter(s)
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
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:
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
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.
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
Hi Anonymous ,
I am not sure what you mean by that, but the "Week" field on the x axis is from the CALENDER table.
The values on the y axis are from the UNIT table.
The UNIT table does have a "Week" field, but it's not used in the visual, and has a relationship to a "Week" field in the CALENDAR table which is used in the visual.
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
Hi Anonymous ,
That works, obviously, because the data points are from the same table. I always assumed this worked cross-table as well.
Hi Anonymous ,
Is there anything else about this thread that I can assist you? If no, could you please mark the helpful post as Answered? It will be helpful to anyone who might experience the same problem. Thank you.
Best Regards
Rena