Forum Discussion

LostintheBIu's avatar
LostintheBIu
Icon for Helper II rankHelper II
9 months ago
Solved

Dimension Table Yes/No Slicer - Issue with blank rows

Hi,   I have a Dimension Table "Budget Lines", where I have added a calculated column "Filter Out Budget Line Z?" which is a simple IF statement: If Budget Line is Z, Return "No", Else Return "Yes"...
Need Help
  • GeraldGEmerick's avatar
    GeraldGEmerick
    9 months ago

    LostintheBIu You could use an independent table for your slicer, just Yes and No values and then create a measure that you put in your visual level filter that filters out the Z budget lines only.

Chewdata's avatar
Chewdata
Icon for Responsive Resident rankResponsive Resident
9 months ago

Hello,

It is best to replace the blank/null values in the facttabel with a default value, like "Unknown" or "Missing" and add that default value to the Dimension table.

LostintheBIu's avatar
LostintheBIu
Icon for Helper II rankHelper II
9 months ago

Thanks for the reply. Good idea but unfortunately I cannot replace the blank values in the fact table, because this is accounting/financial data, so the raw transaction data cannot be adjusted from how it is in our ERP system