Forum Discussion

Dunner2020's avatar
Dunner2020
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Displaying values that are not present in the table

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??

Need Help
Show and Tell
Tips and Tricks
  • VahidDM's avatar
    VahidDM
    4 years ago

    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!!

     

1 Reply

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

    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!!