Forum Discussion
Display different values in visuals based on one page filter
I have the below data and am looking to apply a filter to the entire page where I can select a single brand but display visuals for each of the products within the brand. For example, if I had 4 line graphs on a page, if I filter for BRAND_1, I would like to see each graph display data for one of the 4 products. Is this possible? Thank you for your help.
| BRAND | PRODUCT |
| BRAND_1 | PRODUCT_1 |
| BRAND_1 | PRODUCT_2 |
| BRAND_1 | PRODUCT_3 |
| BRAND_1 | PRODUCT_4 |
Is this table a dimension table in a Star schema model? You should design your model along these concepts:
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
And please check out how to create small multiples:
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-small-multiples
6 Replies
- FreemanZ
Super User
yes, it is possible.
1) put [Brand] column to slicer,
2) put [product] column and any value column or measure to plot the visual.
- slatka11
Helper I
hi FreemanZ
I think I was unclear in my explanation so let me please try again:
I have 4 visuals on my report and a table with multiple products and multiple brands, with each brand having multiple products within them. Let's say my data looks like this:
BRAND PRODUCT BRAND_1 PRODUCT_1 BRAND_1 PRODUCT_2 BRAND_1 PRODUCT_3 BRAND_1 PRODUCT_4 BRAND_2 PRODUCT_1 BRAND_2 PRODUCT_2 BRAND_2 PRODUCT_3 BRAND_2 PRODUCT_4 I understand being able to put a product filter on the visuals, but rather than having to update the Product filter on each visual every time I change the Brand, I am looking for the visuals to automatically update with the available products based on the brand that is selected.
If my filter was for BRAND_1, I want each of the 4 visuals to show just one of the products within that brand, e.g. visual one shows PRODUCT_1, visual 2 shows PRODUCT_2, etc.
When I select a new brand, I want the visuals to automatically update with the products which fall under that brand, so again visual 1 shows PRODUCT_1, visual 2 shows PRODUCT_2, etc. I hope this is more clear. Is this possible in Power BI?
Thank you!
- grandtotal
Resolver III
Is this table a dimension table in a Star schema model? You should design your model along these concepts:
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
And please check out how to create small multiples:
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-small-multiples
- slatka11
Helper I
Wow, small multiples gets me exactly what I was looking for. So simple! Thank you so much grandtotal
- FreemanZ
Super User
Yes, Small Multiples. Enjoy it