Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Frederik_D
New Member

Using same slicers to create groups shown in the same graph

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.
Skærmbillede 2024-09-11 145722.png

1 REPLY 1
Anonymous
Not applicable

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.

vjtianmsft_0-1726115040426.png

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

vjtianmsft_1-1726115132228.png

 

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.


Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.