dynamic dimension

Hey Emmy66 ,

Unfortunately it it not that simple to create a solution that will meet your expectation.

This is because of the following.

A visual has a "structure", sometimes this structure is called aesthetics.The structure defines the what column is used on the x-axix, what column is used as legend, etc. The structure of a visual can not be changed using DAX.

This means there is no way to "switch" the column that is used in your visual, based on the slicer selection

Solving the problem requires some kind of trick.

Create a table with two columns, one column that contains the content used inside the slicer, and the other the values from the different columns.

Now you can use the second column as axis or column inside the table visual.

You have to create measure that helps to filter the values column accordingly.

You have to create a measure that is using the axis value to filter the different columns and aggregate your values.

The more "variables" you are using the "longer" the measure will get, as each column needs it's own segment in the measure.

If you need more guidance, please create a pbix file that contains sample data, but still reflects your data model. Upload the pbix to onedrive or dropbox and share the link.

Regards,

Tom