Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Numbers in Matrix Table become blank after adding slicer selected value as column

Just started using PowerBI for a short time. I am adding a constant date column refelecting slicer selected value into Matrix table. It serves as a bench mark date for calculating as-of overdue date....
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Update: 

    Just filter out empty number columns and the result is what I expected. So it's a solution for me.

     

    Thanks so much for comment above. As this constant column only change with slicer so I should not assign relationship for it.

     

     

     

     

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

There are a couple of issues here. Your date table should contain at least all of the dates in your fact table and you probably want a relationship from that table to your fact table.

 

I'd suggest defining your date table like this:

Date_Checking =
ADDCOLUMNS (
    CALENDAR (
        DATE ( YEAR ( MIN ( FACT_Ageing[Start Date] ) ), 1, 1 ),
        DATE ( YEAR ( MAX ( FACT_Ageing[Target Completion Date] ) ), 12, 31 )
    ),
    "Year", YEAR ( [Date] ),
    "Month", MONTH ( [Date] ),
    "Day", DAY ( [Date] )
)

and then creating a relationship

 

You'll still get empty rows most of the time since [Date_Report] is defined independently of the fact table.