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

Can you provide the sample file to take a look at?

  • 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