Forum Discussion

slatka11's avatar
slatka11
Icon for Helper I rankHelper I
3 years ago
Solved

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.

 

BRANDPRODUCT
BRAND_1PRODUCT_1
BRAND_1PRODUCT_2
BRAND_1PRODUCT_3
BRAND_1PRODUCT_4

6 Replies

  • yes, it is possible.

    1) put [Brand] column to slicer,

    2) put [product] column and any value column or measure to plot the visual.

  • 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:

     

    BRANDPRODUCT
    BRAND_1PRODUCT_1
    BRAND_1PRODUCT_2
    BRAND_1PRODUCT_3
    BRAND_1PRODUCT_4
    BRAND_2PRODUCT_1
    BRAND_2PRODUCT_2
    BRAND_2PRODUCT_3
    BRAND_2PRODUCT_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!