Forum Discussion
Issue with Filtering a Line Chart with Fixed Axis
Hi Guys, I am showing distinct count of individuals as per time (5min interval) as per zones. I have three tables: 1) Source: It has data for Individual IDs present in different zones as per...
Hi
I have tried with single filter there but it didnt help. No change.
I have tried with single filter there but it didnt help. No change.
Can you provide the sample file to take a look at?
Hi Anonymous
I added some sample data and created a test PBIX. Its present here:
https://drive.google.com/file/d/1MG80plgaNLlRYlIjQ9mCat3iQ8zLO8X4/view
Let me know if you need anything else.
Mann
The issue appears to be the date and time relationships. Because you're pulling data from Source and using the fixedaxis table as a dimension, and because those 2 tables don't have a time series link, it's pulling in all the data.
I created a separate date table and time table and connected those to the Source table and that seems to work as expected.Let me know if this is what you're looking for.
https://drive.google.com/file/d/18TbLs7cePoUJC1ObW0YX_Mw3a9ygOGJU/view?usp=sharing- Hi There,
Thanks for checking on this. Unfortunately this solution wont help me since I need shift type in fixedaxis table. I realized the issue is with the measure. If I convert that line chart into table visual and remove this measure then records are getting filtered by shift type as expected.