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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors