Forum Discussion
Using date columns from a table as start/end dates for filter
I'm trying to find a way to use the Publish and Lookthru Dates on the table as a filter for the start/end dates on the X axis of the table. Click a line on the table and see the corresponding data on the graph.
I'm sure I'm not the first to try to find a way to do this but haven't been able to find the right article to show me how to accomplish this.
Thank you!
Figured it out!
I went into the X axis settings and used the function setting to choose the Publish Field / Earliest Date for the Start field and LookThru date / Latest Date as the End date. Then I created a filter for the Outlets. When they click on the filter, it uses the dates as the start and and as the X axis range.
2 Replies
Hi dpeacockTHH
You can "edit interactions" (refer here: https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions) which should provide you with what you want. Importantly, if it doesn't, you may need to visit your relationships in the Model view of Power BI to ensure that when you click a respective point, Power BI knows that it is related to the records in the Table.
Hope this helps 🙂
Theo
Figured it out!
I went into the X axis settings and used the function setting to choose the Publish Field / Earliest Date for the Start field and LookThru date / Latest Date as the End date. Then I created a filter for the Outlets. When they click on the filter, it uses the dates as the start and and as the X axis range.
