Displaying values that are not present in the table

[Dunner2020]

Hi there,

I got a table which looks as follow:

Category Name	Value
A	12
B	10
C	15

I'm displaying the category name and its value using table visual in Power BI. Now I wanted to show Category Name 'D' and its value to 0 in the table visual. As you can see that Category Name 'D' does not exist in the table. However, I wanted to display in the visual. Is there any way of doing that? Any suggestions??

[VahidDM · Accepted solution]

Hi @Dunner2020 

You can use DAX to create a new table, a calculated table, like so (Modeling Menu --> Calculations ribbon --> "New Table"):

new table = 
UNION(
    'Table'
    , ROW(
        "Category Name", "D"
        ,"Value", 0      
    )
)

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

Appreciate your Kudos!!