Blank Value to be appear as Unknown in PowerBI

[arun2001mjl]

Hello All,

Need Help.

In Excel, under Priority there is lot of Blank Rows without Priority.

Example:

Critical: 20 Tickets

Top: 10 Tickets

P2: 40 Tickets

High: 10 Tickets

P3: 80 Tickets

Medium: 20 Tickets

P4: 80 Tickets

Low: 20 Tickets.

Blank: 120 tickets.

I have a Mapping file for above Priorities as follows:

Critical	P1
Top	P1
P2	P2
High	P2
P3	P3
Medium	P3
P4	P4
Low	P4
Blank	Unknown

Now, in PowerBI, i need a Output as follows:

P1	30
P2	50
P3	100
P4	100
Unknown	120

But iam not getting as "Unknown"/"Blank", It is showing 120 without any Text in Priority.

Please help me to bring "Unknown" / "Blank" in PowerBI for blank rows.

[amitchandak · Accepted solution]

@arun2001mjl , if you have a join on Priority, you should be able to see data for Unknown. But if the join is on Critical column, then you have to replace blank /null value with some value (N/A) in the power query, then it will come correct

Power Query Replace Value: https://youtu.be/hkZhZbR7Kmk