How can we remove the (none)

Hi,

Just wondering how can we remove the “none” value here:

Hello @jemelyn_may_hipona !

Use AGGREGATE in conjunction with EXCEPT.
See here more details: Except

Edit your “Remove (none)” calculated member in “How did we do?” dimension to something like:

Aggregate(
  Except(
    [Issue Type].[Issue Type].Members,
    {[Issue Type].[Sub-task],
     [Issue Type].[Integration Subtask]}
  )

)

The chart should look like this (make sure you select your calculated member):
image

Hope it helps!
VasileS.

1 Like

I have a similar query. For my pie chart, how can I remove the “none” value?

@VasileS

Should work the same as described… add a new calculated member in your “Source” dimension.
For “testing” purpose switch your chart to table view:
image

To add a calculated member you need “Reports admin” access rights to your account:
image

Kind regards,
VasileS.

1 Like