Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello, I believe I have a quite complicated problem and I can't seem to find a solution anywhere. I want to be have an interface where, using the same 3 (or more) slicers the user would be able to select group 1, set the slicers, and then select group 2, select slicers for that group and have BOTH group 1's and 2's results shown in the graphs above.
Also I have made the graphs such that the user is able to choose between results to be shown, but I believe that does not complicate this grouping logic problem.
Hi,@Frederik_D .I am glad to help you.
If you want to realize the effect of slicer grouping, you can change the interaction behavior by editing the slicer, for example, when selecting the groupID slicer, so that it can only have a filtering effect on the selected slicers.
For example, if you select the nowTime slicer here, you can set whether other visuals on the same page will be affected by the slicer field, thus realizing the effect of hierarchical control of visuals.
You can also choose to write a specific measure, using the dax function to realize the effect of the display of the visual control, for example, set a measure, apply it to the final chart visual, in the measure to determine the selection of the slicer, return the corresponding tag value, in the filter area will be the measure as a filter condition, and the measure will be used as a filter. Realize to pass the value through the slicer to change the value of the measure, and then use the value of the measure as a filter to control the display of the visual.
Below is the official documentation I found on this subject I hope it helps. Note that the relationship between tables affects how the slicers interact with each other, so you need to choose the right solution for your situation.
URL:
Change how visuals interact in a report - Power BI | Microsoft Learn
Filters and highlighting in Power BI reports - Power BI | Microsoft Learn
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 37 | |
| 33 | |
| 29 | |
| 26 |
| User | Count |
|---|---|
| 134 | |
| 104 | |
| 63 | |
| 60 | |
| 55 |