Blanks on a clustered bar chart that I need to show but want to show as 'Not answered'

[Amy-Marriott]

Hi there,

I have built out a report where I have a Parent table with All headcount and have then created relationships with necessary questions and answers. What I need to show is that X answered in this specific question but that the parent chart has people that haven't answered/not been asked to answer but it just shows them as blank currently as I am pulling the parent ID as the values field. Am I able to change the name to say 'Not Answered' instead of it pre populating it to blank?

Thanks in advance!

[mlsx4]

@Amy-Marriott Try to add a measure with the field you are displaying that checks for blanks. Let's say your values are called answer

measure= if(ISBLANK(answer), "Not answered",answer)

[NishPatel]

You can create an additional custom column with IF statement refrencing to your answer column and use that column for Y Axis.

[Amy-Marriott]

Thank you Nish, which table do I create the custom column in? The answer tables do not have blanks in them, its the parent table that will show blanks as there are ID's in the parent table that aren't in the answer table i.e. these are the blanks that I would like to change to 'not answered'

[NishPatel]

First create a custom column in your answer table as Result = 1. Then create custom column in Parent table as 

Custom = IF(LOOKUPVALUE(Answer[Result],Answer[ID],'Parent'[ID])=1,"No","Not Answered"). This will show No for all that are in your answer table and Not Answered for the rest.