If and else

[Cotadwaree]

Hello,

I have a column called XYZ in an excel which has the values of 123, 456, 789, OTHER, EXPIRED in each rows respectively. How can i group or convert the (123, 456, 789) as ACTIVE.

Currently Power BI  will appear 5 bar charts of 123, 345, 789, OTHER, EXPIRED

When i add a Conditional Column, i do:

If XYZ equals "OTHER" then "Other Partners"

Else if XYZ equals "EXPIRED" then "Expired Contracts:

OTHERWISE "ACTIVE"

And when the Conditional column is created, the ACTIVE is not grouping the (123, 456, 789).

But i would need Power BI to show only 3 bar charts only such as ACTIVE, OTHER, EXPIRED.

Can you  please help me how to fix this?

[Vvelarde · Accepted solution]

hi @Cotadwaree

Look if you are following the same steps.

[Cotadwaree]

Hello,

Yes Now it's working perfectly.

I'm not able to understand why it did not work or which mistake i did and it was not working.

but after watching your picture, now it's working..

Man thanks a lot.  You are genius.

You truly saved my day...