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

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 :)