Column variable

[DavidB023]

Hi everybody,

I would like to create a variable column function of a slicer. In fact, I have a table with columns named by year and another table with just years which create my slicer.

In fact, I want a column with a kind of "switch" function which when I choose a year in my slicer, the variable column takes values from the targeted column.

Typically, these are my two tables, and the last column will be my variable. In fact, when my slicer = 2017, I would have "Commentaires 2017" into "Commentaires" ...

Best regards

David

[TomMartens · Accepted solution]

Hey,

basically this not possible due to the following:

The interaction of the user with datamodel, eg using a slicer (meaning rows of connected tables are filtered) does not allow to influence the content of a column, even if a calculated column is used.

For this reason, the only possible way to achieve what you are looking for is to create a measure.

Without sample data it's very hard and time consuming to provide more guidance.

I would recommend to prepare a pbix with some sample data, upload this pbix to onedrive or dropbox and share the link.

It would also be helpful to explain the expected result in more detail, at least for my understanding.

Regards

Tom  

[DavidB023]

@TomMartens


Thanks for your answer, it looks difficult, I sucess to avoid this kind of method.

Best regards

David