Automated value display

[Egon]

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 select what they know, I would like the value of the other slicer to display instead of "all" that normally shows up. In other words, when they pick a value on one slicer the other one will automatically select the (single) value in the second slicer. Once the first slicer is chosen, the second will only have a single option due to the filtering, I simply would like the value to display on the second slicer without having to manually select it. 

This should work for both slicers since they wont always know inv#, they may know tray #

thanks you much in advance

Ian

[PaulDBrown · Accepted solution]

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]

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

[Egon]

Hi Tom

The backbone is an Excel table and both slicers are populated from the same table. The second slicer DOES filter so only the single "tray" is in the dropdown list once you pick from the inventory # slicer. I would simply like to display that single entry automatically instead of the "ALL" that shows in the second slicer.

This is really a minor thing I am trying to do, just trying to save the user form having to click the TRAY slicer to see what the tray value is. 

thanks 

Ian