Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Change group source column

Hello,

I created a group from a source column and I'd like to know if there is a way to change the source column of my group.

 

Example:

Source ASource BGroup
AA 
BA 
CB 
AB 
BC 
CC 
AA 
BA 
AB 

 

My Group column grouping is originally based on column A.

I'd like to modify my Group column source so it becomes based on column B.

 

The reason is because my Group column is used in dozens of tables and graphs, in a dozen of pages. And if I create a new Group colunm based on column B I will have to manually modify all the tables and graphs already created !

 

Thanks for any help you can provide,

Toftaf.

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

     

    After my testing, PowerBI does not currently support changing this Field. But I think your idea makes sense and you can submit an idea for it at: Home (microsoft.com) and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

     

    Hopefully this will be possible in a future release.

     

    Best Regards,
    Yulia Xu

     

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

3 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    2 years ago

    Hi Anonymous 

     

    I'm not following what you mean.  WHat is a 'Group Column'?  How do you use this with your data?

     

    Please provide example sof what you have now and what you want as a result.

     

    Regards

     

    Phil

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hello Philip,

      Thanks for your answer.

      I created the example below to try to give a better understanding.

      Basically the question is: Is it possible somehow to change the "Field" of a group after the group is done ?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Anonymous 

         

        After my testing, PowerBI does not currently support changing this Field. But I think your idea makes sense and you can submit an idea for it at: Home (microsoft.com) and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

         

        Hopefully this will be possible in a future release.

         

        Best Regards,
        Yulia Xu

         

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