Forum Discussion
Line chart based on a filtered table
Hi all,
I am working in a report where I have a table that gets filtered by a year slicer. I have data frem vehicles and a deviation value. So the flow would be that when the user filters by year the table would only show the vehicles afected by a certain deviation.
I also have another linechart which I would like to show only data for those vehicles that appear prevously filtered in the table.
Would that be possible? In my mind it should be possible, but haven't figured out how.
Thanks in advance 😃
2 Replies
It should be possible, assuming the correct relationships are set up in the data model.
Vehicles and your main table (that gets filtered by the Year Slicer) should have a relationship where the direction would be: Vehicles filters MainTable.
Now, on your report page, when you have selected a deviation value ----> that will filter your vehiclesTable ----> that filters your MainTable, which is seperately filtered by the Year slicer as well.In regards to your linechart requirement, if you want to filter the list of vehicles that are also filtered by the year slicer, make the relationship between your MainTable and VehiclesTable bi-directional, meaning both tables can filter each other.
Hope this helps.Give thumbs up, Thanks!
Hi! Thanks for the reply 🙂
I have tried but it didn't work, I think because I missed a detail in my explanation.
The year slicer is filtering a table that contains vehicles that are affected by a deviation (-10% or +10%), that means that it's not showing all the vehicles.
While in the line chart I am showing all the vehicles, not only those affected by the deviation, so when I filter by year, it can be the case that in the table only 2 appear, meanwhile in the line chart there are 20.
I have tried adding a filter page but doesn't work, I think it has to do with the model itself.
