Slicer from 2 different columns

[Anonymous]

Hi,

I have 2 status column I need to have a slicer for the usere from both the columns .

I should create a column if the Status is Active from Active_Status irrespective of anything in Unavaliable_Status and I should get Unavaliable if the value is unavaliable from Unavaliable_Status.

[Anonymous · Accepted solution]

Hi @Anonymous ,

If you two status columns can be shown in power query, you can try to merge. 

Select two columns in Power Query and right-click to select merge columns.

Click OK.

Or you can create a calculated column.

Required result = IF([Acitive_Status]=BLANK(),[Unavailable_Status],[Acitive_Status])

You can check more details from

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly..

[Tahreem24]

@Anonymous ,

Try to create Calculated Column like below:

Column = IF(ISBLANK(Tbl2[Available Stautus])=FALSE(),"Active","Inactive")

[Anonymous]

@Tahreem24 ,

All the blank are filling up as Inactive

[Tahreem24]

@Anonymous  - It was Active Status:

Column = IF(ISBLANK(Tbl2[Active Stautus])=FALSE(),"Active","Inactive")

[Tahreem24]

@Anonymous  so tweak your DAX like this:

Column = IF(ISBLANK(Tbl2[Active Stautus])=FALSE() OR ISBLANK(Tbl2[Unavailable Status],"Active","Inactive")

[Anonymous]

@Tahreem24 ,

This is my requirment 

Rule_1 : When Active_Status = "Available" and Inactive_Status ="Unavailable" or "".

Rule_2 : When Inactive_Status = "Unavailable" and Active_Status = "Available" or "".

[Anonymous]

@Tahreem24 ,

Column = IF(ISBLANK(Tbl2[Available Stautus])=FALSE(),"Active","Inactive")

I dont have column called Available Status, what is it refreing for ?

[amitchandak]

@Anonymous , Create a new column like

if(isblank([Active_status]), [Unavaliable_Status],[Active_status])

[Anonymous]

@amitchandak ,

I used same formular .

Here is what I am getting.

[amitchandak]

@Anonymous , try like

if(isblank([Active_status]) || [Active_status] = "", [Unavaliable_Status],[Active_status])

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

I have shared the sample data to your mail please check 

[Anonymous]

Check your email

[amitchandak]

@Anonymous , there is no email in my inbox. Can please share again

[Anonymous]

amitchandak.1978@g***l.*om