Forum Discussion

Santoshepuru's avatar
Santoshepuru
Frequent Visitor
4 years ago
Solved

Display based on slicer

Hi! I have information of 15 products. Each product can be compared to a few products in the list and not with all products..so what I need is if I select a product from slicer I need to have a bar c...
  • Whitewater100's avatar
    Whitewater100
    4 years ago

    Hi:

    When you set up your model(or table), your products table will want to have a field that shows which products can be joined together. Like assigning a category or brand for each product. Something like below shows how Power BI wil be able to pick up and report on related products. E.g., if product A is chosen than products D & F will be able to be compared in a visual or table/matrix.

     

    I hope this answers your question. Thanks..

     

    ProductGrouping_IDOther InfoOther Info
    A1  
    B2  
    C3  
    D1  
    E3  
    F1  
    G3  
Santoshepuru's avatar
Santoshepuru
Frequent Visitor
4 years ago

Thanks for the reply. How to get a bar chart once i have the grouping. 

  • Whitewater100's avatar
    Whitewater100
    Icon for Solution Sage rankSolution Sage
    4 years ago

    You would have other tables, like a fact table with the products and perhaps sales amounts, dates, etc.  I will attach a data model so you can see the idea more clearly. Once yor model is set up it's very easy to make bar chart.

    You click the chart style you like(Top Right of Canvas)  and put fields in the fields well(Dates and Price) . I will put image here to show.

     

    I hope this is a solution for you..

     

     

    Link for example model:

    https://drive.google.com/file/d/1QgEO4YwQQh2lqtXk1hnwQYVBuv6BbKcS/view?usp=sharing