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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mrichman
Regular Visitor

How to add dynamic column based on selectedvalue result?

Hi Community, 

 

Hope you're doing well is there any way to create a dynamic column based on selectedvalue. I have a slicer with client names and if the slicer has selected a value then I want to have a 1 on that specific row and the others 0. 

 

mrichman_0-1637248479035.png

 

 

Thanks in advance!

1 ACCEPTED SOLUTION
Vera_33
Resident Rockstar
Resident Rockstar

Hi @mrichman 

 

You need a seperate Slicer Table which is disconnected or 1:N Single filter direction

Vera_33_0-1637283824335.png

test = 
VAR CurClient = SELECTEDVALUE(SlicerTable[Client])
RETURN
IF(MAX(Table1[Client])=CurClient,1,0)

 

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi Richman,

 

Hope you are doing well.

I saw your post it's almost similar to my requirements i.e my requirements like I have Slicer on date and there is text column I need to display text values based on date selected in the manner of MTD or YTD format and I also tried to capture the selected value into column buts it's not working for me when I am trying to place value using Selectedvalue it's giving me blank 

Please help me on this that would be greatful and thankful

Surendra

 

 

Vera_33
Resident Rockstar
Resident Rockstar

Hi @mrichman 

 

You need a seperate Slicer Table which is disconnected or 1:N Single filter direction

Vera_33_0-1637283824335.png

test = 
VAR CurClient = SELECTEDVALUE(SlicerTable[Client])
RETURN
IF(MAX(Table1[Client])=CurClient,1,0)

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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