cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jcastr02 Member
Member

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.  Untitled1234.png

 

3 REPLIES 3
Community Support Team
Community Support Team

Re: filtering out data that is blank

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

340.PNG

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jcastr02 Member
Member

Re: filtering out data that is blank

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.  

jcastr02 Member
Member

Re: filtering out data that is blank

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?

 

123.png

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 159 members 1,823 guests
Please welcome our newest community members: