Forum Discussion
Filtering line chart with date
Hi qmestu ,
Since the the slicer is a combination of year and quarter then you can use the disconnected table and with sync slicers that will allow you to get the same result and keep the interactions between all the charts.
Can you please share a sample file so I can try and setup an example for you.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Hi qmestu ,
Since the the slicer is a combination of year and quarter then you can use the disconnected table and with sync slicers that will allow you to get the same result and keep the interactions between all the charts.
Can you please share a sample file so I can try and setup an example for you.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Hi,
I accepted your post as a solution, as it pointed me in the right direction. I created another CalendarTable that is not filtered by anything and used that as the Y axis in my chart.
I then created a measure that compares the date in my slicer to the date in that calendar table, and only shows results where the first is smaller than the second.
Thanks.