Forum Discussion
Filtering a visualization off of multiple columns in a table with different datasources
Super User
Hi Ashish_Mathur! Thanks for the reply! I am still unable to get it to work as expected.
The Filter table should have a start and end date and be used for filtering the visualization. I was hoping to learn how to join the filter table to the volume table on both of those dates so that when you click on Code 7 in the table, it only shows the dates where relevant. In the example below, since the start date and end date are 10/5 and 10/9 then we'd filter out 10/4 and 10/10 data. Is there a way to set date variables based on what selection you click in the table and then pass them to the visualization as only show data between startdatevariable and enddatevariable?
Thanks!!
- Ashish_Mathur
Hi,
Does my solution not achieve that? What happens when you build a visual in the file that i shared with you?
Hi Ashish_Mathur,
No I am not able to get the attached pbi to do what I need. The filter table needs to have a date range instead of just one date and it needs to filter the graph to the right when selected. I pulled out the filter table and the volume graphic below, but you can see when I click on a specific date, it doesn't filter the graphic to the right based on the selection. Does that make sense? Thank you so much for working through this with me - I really appreciate your help!!
- Ashish_Mathur
Hi,
On the file that i shared with you, build your desired visual visual/slicers and share the download link with me.