Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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!
Solved! Go to 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.
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.
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.
Hello, thanks for your response. Is this screenshot okay?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
56 | |
38 | |
34 |
User | Count |
---|---|
99 | |
56 | |
51 | |
44 | |
40 |