Forum Discussion
jcastr02
Post Prodigy
Post Prodigymatrix columns disappearing
I have a matrix visualization where all columns are showing, if I show all results. If I filter, the columns disappear and this is just because no one responded with those (in this case no one respo...
d_gosbell
Super User
Super UserAs I see it you have 2 possible solutions here.
1. It might be possible to adjust your measure so that it returns 0 instead of blank if there is no data. You just need to be careful doing this as it can cause performance issues in some cases.
2. Instead of using a matrix you could use a table and create 5 measures, one for each of your different responses and use those 5 measures on your table. It's hard to be sure without knowing what your data model looks like, but I'm thinking that these measures would use a pattern something like the following:
Strongly Agree % = CALCULATE( [percentage measure], table[Response] = "Strongly Agree")