Forum Discussion
Helper IGraph not corresponding to date slicer
Super UserHi,
Create a Calendar Table with running dates. Create a relationship from the Date column of the Movement Table to the Date column of the Calendar Table. Create another relationship from the Date column of the SpeedCons Table to the Date column of the Calendar Table. Create the Date slicer from the Calendar Table.
Helper IThanks for your time Ashish_Mathur.
In this case, I need to show the speed and consumption of a vehicle chosen from Vehicle table. But, theses figures should pertain to a chosen date range from the Movement table.
Hence, here the speedcons table requires 2 relations (Viz.) one on VehicleId to the Vehicle table and one on the date selection from the Movement table.
If I create a calendar table and relate to the Movement table and/or SpeedCons, then Power BI disallows the second relation Movement table's date to SpeedCons table's date.
This is what the difficulty is. :-(
- Ashish_Mathur
I do not understand your question. Show your datasets and the expected result.