Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
1 year ago

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.

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      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.