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

     

     

     

Sean's avatar
Sean
Community Champion
9 years ago

Lucy64 What do you get if you create the same Chart in the Sample file you uploaded?

And select the Years as in the picture below? If you can simulate your condition in the sample file - upload it again

 

Lucy64's avatar
Lucy64
Advocate II
9 years ago

In the sample file where I got the measures the line value is working when I filter, I cannot duplicate the errors I have in my dashboard, let me share my file with you here

 

  • Sean's avatar
    Sean
    Community Champion
    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

     

     

     

    • Lucy64's avatar
      Lucy64
      Advocate II
      9 years ago

      Thanks for your help.  Greatly appreciated.