Create a slicer based on multiple fields of data

[Sam-L]

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 different field for different interventions which contain either a blank (intervention not carried out) or a date/time (intervention took place at that moment). Ideally, I'd like to create one new column that would pull in this information i.e. Field Name: Intervention_Type with values separated by ( | ) i.e. Intervention1|Intervention2|Intervention3 - based on if a time is valid in those fields.

Failing the above, a new column for each intervention with a replacement of blank values which shows 'No' instead and where there is a time showing 'Yes', would suffice. Is this possible to do?

Thanks in advance!

[Sam-L · Accepted solution]

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.

[v-jingzhang]

Hi @Sam-L 

You could use below codes to create calculated columns. Is this what you want to get?

Column = [A_Time]&"|"&[B_Time]&"|"&[C_Time]

Column 2 = IF(ISBLANK([A_Time]),"No","Yes")&"|"&IF(ISBLANK([B_Time]),"No","Yes")&"|"&IF(ISBLANK([C_Time]),"No","Yes")

Column 3 = IF(ISBLANK([A_Time]),"No",[A_Time])&"|"&IF(ISBLANK([B_Time]),"No",[B_Time])&"|"&IF(ISBLANK([C_Time]),"No",[C_Time])

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[amitchandak]

@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]

[Sam-L]

Hello, thanks for your response. Is this screenshot okay?