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

PaulDBrown's avatar
PaulDBrown
Community Champion
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