Switch columns in matrix using slicer

[Anonymous]

I want to change the data from a matrix using a slicer, as a result the whole column but only the values from it should be changed. The data is all in an Excel file.

ext

tot

ava

example for the slicer

	Jan	Feb	Ma
T1	99	76	76
T2	77	90	98
T3	100	87	76

Example for the Matrix

		ext	tot	ava
T1	Jan	99	100	34
T2	Feb	88	56	75
T3	Ma	99	77	66

Example for the table

Any help would be nice, i need the true values from the table and not any aggregated.

[Anonymous]

Hi @Anonymous ,

What's your expected result? I'm not clear about your requirement. Do you want to change the values base on the slicer selection? Could you please provide some raw data and expected result with specific samples and calculation logic? It would be helpful to get the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards