Ayuda! Remover espacios blancos y mostrar porcentaje de no respuesta:

[sdntiago]

Estoy buscando ayuda ya que necesito que no muestre los espacios en blanco como lo muestra en la foto pero si necesito que aparte me muestre el porcentaje de las personas que no respondieron.

 

Hola

[v-cazheng-msft · Accepted solution]

Hi @sdntiago,

Currently, there is no method to hide a legend item but keep its sector in pie chart. You could try this workaround: create a Calculated column to mark the blank item as unknown to distinguish these items.

Classified = IF('Table'[Response]="","Unknown",'Table'[Response])

Then, the result looks like this.

Also, attached the pbix file as reference.

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun

[amitchandak]

@sdntiago , My advice would be to create a new column

if (isblank([Response]), "Do not response", [Response])

and use that in visual