Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi team,
below is the screenshot of my sample data.
I want to add below column in this table.
I want to use this column in Chiclet slicer, so when i select e.g. country x, then date_x should get copied to date column.
Can you please help?
Thanks!
@Anonymous ,
You can use something like this:
Selected Date =
IF (
SELECTEDVALUE ( Table[region] ) = "x",
SELECTEDVALUE ( Table[date_x] ),
IF (
SELECTEDVALUE ( Table[region] ) = "y",
SELECTEDVALUE ( Table[date_y] ),
IF ( SELECTEDVALUE ( Table[region] ) = "z", SELECTEDVALUE ( Table[date_z] ) )
)
)
Please let me know if this didn't work.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!