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

I am not totally sure I understood your problem, but when I add two slicers - One for Account and one for Day I get the expected result (attached in the screenshot)

 

 

Or did you mean do you wanted to add a slicer and then upon the slicer limit it to a few defined options?

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.