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

     

     

     

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

Lucy64

 

In this scenario, please make sure the "Show item with no data" for the field on X-Axis is not selected.

Then you can apply visual level filter to filter the empty or 0 values.

 

 

Regards,

 

Lucy64's avatar
Lucy64
Advocate II
9 years ago

Hi Simon,

 

"Show item with no data" is not selected.

 

When I try to filter on the line value I get Unexpected Error