Forum Discussion
Display different values in visuals based on one page filter
- 3 years ago
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
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!
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
- slatka113 years agoHelper I
Wow, small multiples gets me exactly what I was looking for. So simple! Thank you so much grandtotal
- grandtotal3 years agoResolver III
I'm glad it helped.
Please mark my answer as Accepted to help others, too. Thanks!