Forum Discussion
filtering out data that is blank
Please see attached screen shot. I have some Modules with questions. Not all modules have the same number of questions. I am doing a funnel chart so I can see performance by question. I have a slicer on the funnel chart so I can filter by module name. If the data (in excel) is blank, I'd like it to not show. Essentially, I should only show when there is a relevant score in excel. I've tried to use filtering as well, but seems it doesn't even let me type anything into the "is less than' field.
3 Replies
Hi jcastr02,
It seems that Q1, Q2 is measure , right? You said you can't type value in less than field, what did you type before? It seems only recognize numeric type when it is measure. In addition, if you want to remove blank, you could set filter like below
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello there, yes they are set as measures, but it won't let me type anything. Also, I've tried using the filter you described below but it's still not taking Q11-Q15 out of the chart. They show up as empty spaces.
Hello, Here is another example of where if I select a certain item in the table, I don't want to see values that are equal to 0 or have no data? I've tried to use the filters you mentioned above, but they still show up?
