Forum Discussion
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 chart which has only products which it can be compared to. Help me with this. I am new to power bi and dax. Thanks in advance.
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..
Product Grouping_ID Other Info Other Info A 1 B 2 C 3 D 1 E 3 F 1 G 3
3 Replies
Whitewater100Solution Sage
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..
Product Grouping_ID Other Info Other Info A 1 B 2 C 3 D 1 E 3 F 1 G 3 Thanks for the reply. How to get a bar chart once i have the grouping.
- Whitewater100
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