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.

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

Thanks for the reply. This sounds promising. Please could you give an example of how the measure could be written? 

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

Nevermind, Chat GPT helped write me a formula! Thanks for the idea 🙂