Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Replace two columns

So, I have two columns of the same values but with different sources. Let's call it "Revenue A" and "Revenue B". All throughout my report, Revenue A is used, but now we've found an issue with the dat...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous,



 

It seem that the Column Revenue A and Revenue B are from different tables and you want to replace Revenue A to Revenue B in the visuals?

 

Though you could change the name of Revenue B to "Revenue A", I'm afraid that makes no sense for visuals as the filed in the visual is from the original Revenue A.

 

If it is convenient, could you share some data sample which could refroduce the scenario and your desired output so that I can understand your situation better and have a test.

 

Best Regards,

Cherry

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

     Cherry,

     

    No, the two revenue columns are in the same table. I've uploaded a sample PBIX here:

     

    https://we.tl/t-Hnz8jYLdjD

     

    The desired output allows me to switch all of the visuals that use Revenue Source A with Revenue Source B, without having to manually update each visual. As if I'd renamed the two columns to have the opposite name, and Power BI allowed the visuals to pull from the column with the same name, instead of seeing that I updated the names and continuing to use the same column with its new name.

     

    Obviously I can just change which column is in the visual, but since the actual file has hundreds of visuals, I'm trying to find a more efficient way.

     

    Thanks.