Forum Discussion
How to have multiple groups to be shown on multiple graphs together
Super UserHi Anonymous -Yes, you can create a page in Power BI where users can select different groupings based on various criteria and have these groupings reflected across multiple visuals.
If your groupings are based on specific criteria, you can create calculated columns or measures. example we will consider age factor as below:
Age Group =
SWITCH(
TRUE(),
Sales[Age] <= 20, "Under 20",
Sales[Age] <= 30, "20-30",
Sales[Age] <= 40, "30-40",
Sales[Age] <= 50, "40-50",
"50+"
)
For numeric data, you can also use the Grouping or Binning feature in Power BI to automatically create groups.
if you can share sample data , that would be better to share different views.
Hope it helps.
Maybe my explanation was insufficient. I want my setup to look like the screenshot below such that a user can use the interface to 100% dynamically define groups using different slicers for each criteria-column and then get shown the results of the group of users matching each segmentation in each of the graphs.
So below there should be two lines on each graph showing the results for each segmentation. (Where each segmentation of users is defined using the slicers).