Forum Discussion
How to Change a Label Name on a Legend
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
Hi Anonymous , 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.
3 Replies
Tahreem24Super User
Anonymous 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.
Hi Anonymous , 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.