Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Change value in column based on slicer

Hello, I have this issue where I make another column from past column, but for one type of values I want to change based on what is selected on Slicer. Logic should be if the "Type." column va...
Need Help
  • coskuersanli's avatar
    coskuersanli
    4 years ago

    You can create 3 visuals over each other, hide 2 of them and create a bookmark. You should select all 3 of them while creating the bookmark from selection pane. After that, please select "Selected Visuals" and untick "Data". You should create a bookmark for each visual and assign it to a button.

     

    Hope it helps ğŸ™‚

     

     

     

coskuersanli's avatar
coskuersanli
Icon for Resolver III rankResolver III
4 years ago

Hi Lukas,

 

I believe it's not possible to change a column dynamically. You can create a measure instead. Can you try below one and check it in a table visual.

 
TypeX = IF('2022'[Type.]="Intercompany ACMI",
SELECTEDVALUE(Company)

 

,'2022'[Type.])

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    It seems to show values as (Blank). 

     

    I wonder what could be the the solution then. Create different columns, one for company A, one for company B and one for both. And then change visual based on slicer, but slicer would just take different column into the visual then. What you do think about this? Is it possible this way?