I have a problem and don't know how to solve this. Maybe anybody here has some good ideas.
I have a filter (1) and want to use the selected value as a maximum value for the calculation in (2), but the selected value in (1) should not act as a filter in (2). I only need a selection for a maximum and not a filter. Is this somehow possible?
At the moment all available weeks are shown in (2), because (1) and (2) are not connected. When I connect them only one week is shown, because it filters. I want to choose a value e.g. 12B, then (2) should only show weeks which are before 12B.
Data looks like this:
Name / Week
11D -> 2017/51
12A -> 2017/52
12B -> 2018/01
12C -> 2018/02
So when I choose 12B, it should show me 2017/51, 2017/52, 2018/01 and NOT 2018/02.
Just disable cross-filtering. Click on your Slicer (1). In the ribbon under "Visual tools" choose "Format" and then "Edit Interactions". Click the ghostbuster icon in your other visual to turn off cross filtering. Click "Edit Interactions" again to revert to not editing interactions.
I've already tried that. That's what i've meant with "are not connected". But if i do that, (2) does not know what is selected. But (2) needs to know what is selected in (1), because the maximum shown week should be based on that value.
You can create a measure to get the week based on the selected value in filter1 using the fomula.
week based on selected value = CALCULATE ( MAX ( Table[week] ), FILTER ( Table, Table[Name] = SELECTEDVALUE ( Table[Name] ) ) )
Then use the measure above in the visual level filter for visual2. Filter week less than [week based on selected value] measure.
My Power Bi somehow doesn't know SELECTEDVALUE. But anyways, is it possible to do it without using the filter on the UI? We user Power Bi Server and provide a Web Interface with an embedded report. Our users are not very familiar with such tools and it should be as easy as possible. So the user should select a name in (1) and the diagram in (2) should show the correct weeks without any extra configuration or filtering.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.