How to Change a Label Name on a Legend

[Libbyb23]

Hi, 

I need to change the blank grey part of the pie to say All Other Sales. how do I do that?

Kind regards!
Libby

[Tahreem24]

@Libbyb23  Create a new column like below:

New Column = IF(Program Type = Blank(), "All Other Sales", Program Type)

Then use this new column instead for Legend.

[Libbyb23]

I am using Analysis Services, is there a way to do this using this?

[Anonymous · Accepted solution]

Hi @Libbyb23 , hello Tahreem24, thank you for your prompt reply!

The short answer is NO.

In Live Connection mode,  data modeling and field grouping in Power BI depend on the data source, making it impossible to perform local data grouping or create calculated columns.

Therefore, we recommend adding a calculated column for the Solution Program Type field in SSAS, and then use it in Power BI.

Best regards,

Joyce

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