Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Column legend filtering X-axis

Hi guys, I have a report combining 2 fact tables. One table with actual sales and one with forecast sales. The actual sales table extends to the current month (so March 2023 as I'm writing this), ...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    While I agree that this can be considered a bug there is a workaround. See if you can spot it.

     

    see attached.

lbendlin's avatar
lbendlin
Super User
3 years ago

While I agree that this can be considered a bug there is a workaround. See if you can spot it.

 

see attached.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

lbendlin How interesting, I did try the 'show items with no data' option but it didn't work with the automatic date hierarchy.


Below, with a date slicer on 2023 dates and using the 'show items with no data' option, all dates in the calendar are shown going up to 2026 despite the slicer.

But, as you have done with your file, this option does work when you use the date hierarchy I created myself as shown below.


I can't say I quite understand why this would be the case, but I'm glad to have the solution!

Thanks so much for the help on this, stopped me from tearing my hair out.

Cheers,

Paddy

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    In most cases you want to avoid the auto date/time feature. It can have massive side effects.