Forum Discussion

olik's avatar
olik
Icon for Helper I rankHelper I
8 years ago
Solved

Slicers: Only show available values

Hi all,   What's the Power BI equivalent of Tableau's "show only available values" in a filter?   Main table: Day Account Value 1 A 0.1 2 A 0.2 3 A 0.3 1 B 0.4 2 B ...
Need Help
  • nirvana_moksh's avatar
    nirvana_moksh
    8 years ago

    Just change the filtering to 'Both' in the relationship side

     

    RESULTRELATIONSHIP

nirvana_moksh's avatar
nirvana_moksh
Icon for Impactful Individual rankImpactful Individual
8 years ago

Just change the filtering to 'Both' in the relationship side

 

RESULTRELATIONSHIP

sliceNdiceUup's avatar
sliceNdiceUup
Frequent Visitor
3 years ago

An easy shortcut is creating related columns from the lookup tables within  transaction table. If you then choose the related columns from the transaction table as slicers everything will automatically cross filtered inside the transaction table so by default you will only see the lookup variables that exist inside the transaction table.