Show category value as 0 even if there is no data in table

[mganapathy2]

I have a table with values as Blue,Red,Green under the column Colours

I want display the value Black but this Black value is not available under the column Colours  in the table

I am using Power BI desktop to display the above in chart like below. Currently it display only for available values 

How do I display for the value Black as 0 even though if it is not available in the table Colours column

Blue 100

Black 0

Red  75

Green 67

Please let me know how to thi sin power bi 

[mganapathy2]

Hi prateekraina,

I am looking to create on the fly without creating a table for Black

like hard code the value and check the count to display .

IN SSRS we do like =IIF( field1= 'Black', 'Black : & 'count(field1),'Black : & 0)

Please let me know

[mganapathy2]

Currently I do not want an entry inside the table.,am looking for an formula to check if that value exists  on the fly and isplay th e count on the fly.

[v-jiascu-msft]

@mganapathy2

Hi,

It seems that you can’t add Black into table directly. So you need two tables.

1. Create a table for black: Table2.

Colours   value

Black        0

2. Create a table for all colours.

ColourTable =
DISTINCT ( UNION ( VALUES ( Table1[Colours] ), VALUES ( Table2[Colours] ) ) )

3. Establish relationship.

4. Create report.

Best Regards!

Dale