Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Thanks in advance!
Solved! Go to Solution.
Hi @mrichman
You need a seperate Slicer Table which is disconnected or 1:N Single filter direction
test =
VAR CurClient = SELECTEDVALUE(SlicerTable[Client])
RETURN
IF(MAX(Table1[Client])=CurClient,1,0)
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
Hi @mrichman
You need a seperate Slicer Table which is disconnected or 1:N Single filter direction
test =
VAR CurClient = SELECTEDVALUE(SlicerTable[Client])
RETURN
IF(MAX(Table1[Client])=CurClient,1,0)
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |