Forum Discussion
Slicer doesn't affect matrix
Apologies, I tried this again on my own computer the issue is the dat_date is marked as a date table which makes complete sense but however it is causing your problem.
What you need to do copy the code for dat_table and then remove it from your model, then stick it back in again but this time don't mark dat_date column as a date table. Then make sure dat_date is formatted as below...
This should do the trick.
Now make the relationship you were looking to make to 'betriebstag' but make sure 'betriebstag' is in the same format as dat_date.
Hopefully this should work!
Helper IIIHi, according to your relationship you should be able to filter on the table from your Date Table. If I were you I would change the format of dat_date to Date format Long Date but make sure it doesn't break your model if it is big! Give that a go see if that fixes it.
Helper IIIApologies, I tried this again on my own computer the issue is the dat_date is marked as a date table which makes complete sense but however it is causing your problem.
What you need to do copy the code for dat_table and then remove it from your model, then stick it back in again but this time don't mark dat_date column as a date table. Then make sure dat_date is formatted as below...
This should do the trick.
Now make the relationship you were looking to make to 'betriebstag' but make sure 'betriebstag' is in the same format as dat_date.
Hopefully this should work!
Thanks!! 🙂