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

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

nirvana_moksh: Sorry, turns out my example was too simple - I've updated the original question now!

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

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

    Ah, perfect - that does the trick!

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

      I have worked with Tableau and I have loved it a lot, but Power BI is pretty awesome and you will surely find all functionality in it :)

  • 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.