Forum Discussion

Mann's avatar
Mann
Resolver III
6 years ago

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...
Need Help
Mann's avatar
Mann
Resolver III
6 years ago

Hi v-lili6-msft 

 

Thanks for checking on this. This change is also not helping me since this defeats the purpose of having fixed start and fixed end time on x-axis.

If we replace 0 by Blank(), it helps in restricting records of other shift type on x-axis in line chart but it also removes the fixed start and fixed end time. 

For example: If for DS, last non blank values is at 5:00 PM then x-axis is shown till 5:00PM only. I want x-axis to have fix start and fix end time as per fixedaxis.

 

Thanks

Mann

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  Mann 

you could enable show items with no data for [Date Time]

 

Regards,

Lin

  • Mann's avatar
    Mann
    Resolver III
    6 years ago
    Hi Guys

    I had to use Shift Type filter from Fixed axis only to make this work.
    Somehow applying filter from ShiftType table doesnt work for this measure.