Replacing columns in a Matrix...

[Anonymous]

I have a matrix with 12 months representing 12 months of the first fiscal year. I want to swap out those twelve columns with the 2nd fiscal year of a biennium. Is that possible?

so

FM01 FM02 FM03 FM04 ...

0.0        2.0       120.0   24.5     ...

swap this in

FM13 FM14 FM15 ...

2.0        12.3    11.7

Thanks!

[v-lid-msft]

Hi @Anonymous ,

Sorry for that, but we cannot understand your data model clearly, Could you please provide a mockup sample  based on fake data or describe the fields of each tables and the relations between tables simply? What is the column you used in the matrix field? Does the FM01 is the column header of matrix visual?  Please upload your files to OneDrive For Business and share the link here if it don't contain any Confidential Information or Real data.

Please don't contain any Confidential Information or Real data in your reply.

Best regards,

[Anonymous]

I provided that already. It is a really simple model. One matrix table with a couple of columns with data and then swap columns. Basically dynamic columns.

Even more simplier. You have a matrix table with one column say called A then say select a slicer value and column A dissapears to be replaced with Column B.

[amitchandak]

@Anonymous , The information you have provided is not making the problem clear to me. Can you please explain with an example. Can you share sample data and sample output.

Appreciate your Kudos.

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Sample data would be greatly appreciated.