Forum Discussion

mrichman's avatar
mrichman
Regular Visitor
4 years ago
Solved

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. 

 

 

 

Thanks in advance!

Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    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)

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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)

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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