Replace two columns

[Anonymous]

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 data, and want to start using Revenue B. Any calculated columns or measures that use Revenue A can be easily switched, but visuals that use it are going to be a long and annoying process to update. Is there any way to switch the names of the columns, call Revenue B "Revenue A", and have Power BI continue to use what is now "Revenue A", so all the visuals are fixed in a few steps, instead of dozens?

[v-piga-msft]

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]

 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.