Forum Discussion
sea
8 years agoFrequent Visitor
the year filter doesn't work
Hello, I have these tables, the tables are demo: InPower BI I have the following structure: Year Slicer has the date filed from the table activities User Id Slicer has the id_us...
Anonymous
8 years agoNot applicable
You need to change the relationship from single direction for both
Go to Relationship tab -> double click on relation and set the direction of relationship in both
Regards
sea
8 years agoFrequent Visitor
Not work, because when I choose:
id_user -> 30 and year 2018, total target does not change depending on the selected year.
Total target for 2018 for id_user 30 is 60 not 1100
- v-huizhn-msft8 years agoMicrosoft Employee
Hi sea,
If there are relationships between table 'activities' and table 'target activities', table 'user' and 'target activities'? And please confirm the two slicers affect the card by Edit interactions under format.
Best Regards,
Angelia