Forum Discussion

Lucy64's avatar
Lucy64
Icon for Advocate II rankAdvocate 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
Icon for Community Champion rankCommunity 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
Icon for Advocate II rankAdvocate II
9 years ago

Thanks for your help.  Greatly appreciated.