Forum Discussion
Tree Maps report to show sales data
Hi All,
I am new to Power BI and I am trying to design a Dashboard containing 3 Tree maps with the following Data.
- In one we have products and it's related attributes like size, color etc as separate columns like the sample data attached.
- second table is a unpivoted version of the products table in which we have one column for all the attribute names and in other we have attribute value. This table is used to create slicer for all the tree maps
- Third table is a table from where we are pulling the sales data .
All the data sources are blended with product code as the primary key.
My Requirement is to Design Tree maps with sales by attributes and the attributes should be Dynamic. The attributes can be selected from the slicer above and the visualization should change with the selected attribute. Also, the tree maps should be interlinked with each other. If I select an attribute on slicer 1 then sales by that attribute should be reflected in tree map 1. If I select another attribute in slicer 2 then sales by that attribute should be reflected in tree map 2 with correspondence to tree 1 and so on
Taking an example.
In tree map 1 slicer, I have selected color then my tree map shows sales by color. In tree map 2 slicer, I have selected size then it show color wise size in tree map 2. If I select class in slicer 3 of tree map then it should show category wise sales in particular size and particular color.
Also, selecting on any color in tree map should filter the relative data in other tree maps as well.
By this I can get conclusion like which color is selling the most and in which size and category it is selling the most.
1 Reply
- amitchandak
Super User
Anonymous , As small multiple is not supported I doubt there is an easy way to get it
Get index values based and use that as a filter in each visual created. Use allselected
You need to use by name option
Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U