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
I Have the following measure which in placed within a table visual to show the values selected from slicer visual that lists case[Lead Dept] values.
Solved! Go to Solution.
Hi @D_PBI,
there is a work around for this:
1) Remove case[Lead Dept] from the filter pane.
2) add a slicer to you report with case[Lead Dept]
3) select the 5 specified values in this slicer
4) edit the interactions from this slicer(click in the slicer-> Format -> Edit interactions). The default interaction for a slicer is 'Filter', so for the visuals where you don't want to filter by these 5 values, change the interaction 'None'.
5. Now go to View -> Check the box for Selection Pane. In the Selection Pane, identify the slicer you just made, and click on the small eye symbol to hide this visual from you report. It will still filter the other visuals even if it is hidden. If you report is short on space, there is no problem overlaying this hidden visual
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
Hi @D_PBI,
there is a work around for this:
1) Remove case[Lead Dept] from the filter pane.
2) add a slicer to you report with case[Lead Dept]
3) select the 5 specified values in this slicer
4) edit the interactions from this slicer(click in the slicer-> Format -> Edit interactions). The default interaction for a slicer is 'Filter', so for the visuals where you don't want to filter by these 5 values, change the interaction 'None'.
5. Now go to View -> Check the box for Selection Pane. In the Selection Pane, identify the slicer you just made, and click on the small eye symbol to hide this visual from you report. It will still filter the other visuals even if it is hidden. If you report is short on space, there is no problem overlaying this hidden visual
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
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 |