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
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!
Hi Anonymous ,
Please check the below screenshot:
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.