Forum Discussion

MarkD1722's avatar
MarkD1722
Resolver I
2 years ago
Solved

One specific set of data does not display columns except when the slicer is set

I have a very unusual situation with a stacked column chart that I have not seen before.  I have a set of values that I am summing up by Location and plotting along an axis that is the week numbers i...
Need Help
  • MarkD1722's avatar
    MarkD1722
    2 years ago

    Thanks, HotChilli .  Your questions are spot on.  We figured it out with a fresh set of eyes.  Within the switch function, there was no provision for particularly infrequent status that is ultimately supposed to be filtered out.  That location in question happened to have a couple projects with this unusual status, and the switch function appeared to return a completely null set.  I added a line to deal with that status and everything appeared as expected.

MarkD1722's avatar
MarkD1722
Resolver I
2 years ago

Thanks, HotChilli .  Your questions are spot on.  We figured it out with a fresh set of eyes.  Within the switch function, there was no provision for particularly infrequent status that is ultimately supposed to be filtered out.  That location in question happened to have a couple projects with this unusual status, and the switch function appeared to return a completely null set.  I added a line to deal with that status and everything appeared as expected.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi MarkD1722,

Congratulations on solving this issue and thanks for sharing your solution.

 

Please remember to accept your solution as answer.

 

It will do great help to those who meet the similar question in this forum.

 

Thanks again for your contribution.