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
Hello Anonymous ,
When I do that, the graph shows the total amount for every week. I get a horizontal line, which is not correct.
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
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: