Forum Discussion
Switch columns in matrix using slicer
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.
1 Reply
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