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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

  • 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