Forum Discussion
Solved
Create a slicer based on multiple fields of data
Hello, I'm currently working with some medical intervention data and I'm looking to create a new slicer filter which allows the selection of a medical intervention. Currently, my data has a d...
Thanks for your help v-jingzhang amitchandak. I have found a different way around this by creating a conditional column based on if a time exists or not. If a time exists, it stores 'yes', if it's null, it stores 'no'. I've done this for each of my interventions and created a card for each intervention.
Sam-L ,Can you share sample data and sample output in table format?
As of now it seems like a new column
=[Intervention1] & "|" & [Intervention2] & "|" & [Intervention3]
Hello, thanks for your response. Is this screenshot okay?