Use a slicer value to filter a field of a visual in the filters pane

[rpinxt]

Lets say I have a visual and a slicer with 2 titles. Tile A and Tile B

The selection of the tiles determines which GL account I want to filter in the visual.

For instance. When tile B is selected the visual should be filtered on GL account 12345.

And if tile A is selected it should filter/show all GL accounts accept 12345.

Was thinking about a measure to looks which value of the slicer is selected.

That would work but how to pass this to a filter value?

[DataInsights · Accepted solution]

@rpinxt,

This sounds like a use case for field parameters. You could create two measures, one that includes only account 12345, and the other that includes all accounts except 12345. These two measures would be used in your field parameter.

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters 

[rpinxt]

Ah right, thanks @DataInsights field parameters would also be a way to go.

Did it now it bit different approach with the enduser and made DAX formulas that would fit.

But maybe field parameters would have been more efficient 😉