Forum Discussion
One specific set of data does not display columns except when the slicer is set
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.
" The values are being calculated using a SWITCH function keyed off the Status (nothing with Location), but the other sites' projects are not behaving like this"
This, along with the overall description, is all a little too cryptic to help you.
Start with the basics: What tables do you have? What are the relationships? What's the measure definition?
What filters and slicers affect the visual?
If you can't tell us any of this it's going to be difficult to help.
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.
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.