Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everybody,
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.
Any ideas???
Thanks,
kalle
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.
Hi @kalle,
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.
Thanks,
Angelia
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.
Hi @kalle,
You use Power BI report server rather than Power BI desktop? SELECTEDVALUE is supported in BI desktop. And if you use Power BI report server community, you'd better post it to report server community.
Best Regards,
Angelia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |