Forum Discussion
Helper VSlicer and relationship
Hi All,
I am struggling to link two slicers with two tables.
I want to show sales and temperature graph in visual when I select date range and city but I am only able to link with sales but not temp.(or can do temp but not sales - can not do both)
Please help.
All the best,
Paris
Hi Paris,
Could you check if your data model is set correctly (should look similar to the reference in image 1). If the model is correctly defined you should be able to visualize multiple graphs using the same date and city slicer. Additionally, make sure you use the "date" and "city" column from the calendar and label table to slice all visuals at the same time, not the "date" and "city" columns within your sales and temperature tables.
2
1
Best regards,
Tim
1 Reply
- timg
Solution Sage
Hi Paris,
Could you check if your data model is set correctly (should look similar to the reference in image 1). If the model is correctly defined you should be able to visualize multiple graphs using the same date and city slicer. Additionally, make sure you use the "date" and "city" column from the calendar and label table to slice all visuals at the same time, not the "date" and "city" columns within your sales and temperature tables.
2
1
Best regards,
Tim