Forum Discussion

Lucy64's avatar
Lucy64
Advocate II
9 years ago
Solved

Line & Column Chart

I have created the following chart to show current employees total in the line.

 

 

 

 

 

 

 

 

 

 

 

 

However when I view with a filter to select a few years the line does not end on the years selected.  How can I remove the additional years on the visual?

 

Need Help
  • Sean's avatar
    Sean
    9 years ago

    Lucy64 Can you make this file work with the Year as a Slicer and not using the Timeline?

     

     

    EDIT: To make it work with the Timeline get rid of the IF statements that replace blank with 0 in both Measures!

    That seems to work

     

     

     

9 Replies

  • Lucy64's avatar
    Lucy64
    Advocate II
    9 years ago

    In case you need details of the measures, I took them from this example here

    • Sean's avatar
      Sean
      Community Champion
      9 years ago

      Lucy64 Are you using the same field in the Slicer that you using in the Shared Axis of the Chart?

      • Lucy64's avatar
        Lucy64
        Advocate II
        9 years ago

        Yes Sean, it is the date field from the date table.  On the image I sent you I was using the Year column but I switched it to the date field (same as in the chart) and I get the same result.