Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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!