Forum Discussion

Egon's avatar
Egon
Helper I
3 years ago
Solved

Automated value display

Hello   New to power BI so forgive me if this is a simple fix.   I would like a user to select from one of two slicers, they will only know one of the two items. Once the engage the slicer and se...
Tips and Tricks
  • PaulDBrown's avatar
    PaulDBrown
    3 years ago

    To add to what has already been suggested, and depending on how the model is set up, here are a couple more options:

    1) Create a single dimension table for both fields and create the slicer as a hierarchy. The selection then becomes "natural".

     

    2) If you prefer to have 2 separate dimension tables, you can filter the corresponding slicer values using a measure in the formatting pane for each slicer so that only the subset of values are displayed. 
    Assuming the fact table is 'fTable', use this measure:

    Filter slicers = COUNTROWS(RELATEDTABLE(fTable))

    add the measure to the filter pane of each slicer and set the value to greater or equal to 1:

    and you will get

TomMartens's avatar
TomMartens
Super User
3 years ago

Hey Egon ,

 

I assume that the content from both slicers does not come from the same table. Otherwise, it would (at least it should) already working.

Suppose both tables (the two tables that fill the slicers) are connected to a fact table. In that case, you might consider changing the cross filter direction property of the two relationships to "Both" this will help to tackle your challenge.

Changing the Cross filter direction to "Both" can introduce ambiguity to the filter path. Filters follow a path during filter propagation, following from the one-side of a relationship to the many-side of a relationship.

Hopefully, this provides what you are looking for.

Regards,

Tom