Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
DavidB023
Helper III
Helper III

Column variable

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" ...

 

 

comm.PNG

 

year.PNG

 

 

 

Best regards

 

David

 

 

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

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  



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

2 REPLIES 2
TomMartens
Super User
Super User

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  



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

@TomMartens


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

Best regards

David

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.