Forum Discussion
LostintheBIu
Helper II
Helper IIDimension 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"...
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.
MattiaFratello
Super User
Super UserHi LostintheBIu, in Power Query replace blank with a default value of your choice and then add this value to the dimension as well
If this helps please feel free to mark it as solution and to give kudos 👍
LostintheBIuHelper II
Helper IIThanks 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.