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!View all the Fabric Data Days sessions on demand. View schedule
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!