Forum Discussion
How to have multiple groups to be shown on multiple graphs together
Hello, I'm a beginner at Power BI. I want to have a page for users to be able to select lets say 10 different groupings based on many criteria/different columns in the data. (These can be numeric or categorical). Then I want all these 10 different groupings to be shown in all graphs on the page. Such as the amount of items, user's in a grouping, have bought at your company.
Is there any way to do this or work around this problem?
2 Replies
- rajendraongole1
Super User
Hi 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).
