Forum Discussion
Timeline slicer and normal slicer filtering
Hi folks,
I have two data table from excel, Production Data and Well Event data. Both table have variable of well name, date and many others columns. In data modelling, i connected both table to master file using well name (as primary key). My mission is to have visuals updated according to well name slicer and timeline slicer selection. Since all the data connected with relation to well name only, my timeline slicer is only work for stacked area chart for Production table data as the the timeline is coming from the same table. How it possible to have my table underneath from well event data respond to timeline slicer, for example if i select year of 1990, only data for year 1990 appear in the table. I'm thinking of creating new column for both table and apply new relationship with new concatenate variable of well name and date. Is this the correct way to solve this problem? Really appreciate your help.
Rgds
Redz
2 Replies
v-ljerr-msftMicrosoft Employee
Hi redzum,
Have you tried creating another separate table of Calendar with a date column, then relate it to "Production Data" and "Well Event" table, just like you have done with "Gen Well Data" table?
Then you should be able to use the date column from the Calendar table as Timeline slicer, and Well Name from "Gen Well Data" table as a normal Slicer in your scenario. :smileyhappy:
Note: Make sure that the Cross filter direction is set to "Single" for all the relationships with the Calendar and "Well Event" table, or you won't be able to build up the relationships.
Regards
- v-ljerr-msft
Hi redzum,
Have you tried the solution provided above? Does it work in your scenario?
If you still have any question on this issue, feel free to post here. :smileyhappy:
Regards