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 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.
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi Mann 

For your case, you should create the relationship between Fixedaxis table and Source table by Date Time column and Intervals column.

and adjust the formula as below:

ADZone =
VAR _DisCount =
    CALCULATE (
        DISTINCTCOUNT ( 'Source'[IndividualID] ),
        FILTER(Source,
               'Source'[Zone] IN { "A","D" }
        ))
RETURN
    IF ( ISBLANK ( _DisCount ), BLANK(), _DisCount )

 

Result:

and here is sample pbix file, please try it.

 

Regards,

Lin

  • 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.