Competitor Breakdown

[clem312]

Hi,

I have a table with brands, items and a measure

Brand	Value	Item
Brand1	1001	Item1
Brand1	1002	Item1
Brand1	1004	Item1
Brand1	1006	Item1
Brand1	1007	Item1
Brand1	1011	Item1
Brand1	1020	Item1
Brand1	1051	Item1
Brand1	1052	Item1
Brand1	1054	Item1
Brand1	1057	Item1
Brand1	1101	Item2
Brand1	1103	Item2
Brand1	1106	Item2
Brand1	1107	Item2
Brand1	1108	Item2
Brand1	1109	Item2
Brand1	1111	Item2
Brand1	1120	Item2
Brand1	1130	Item2

I need to represent the items and their percentage for each brand in column.

Ranked by descending order like this :

Link to data file

Link to pbix file 

Clement 

[Anonymous · Accepted solution]

You'll have to create separate visuals/tables for each brand. Currently, as much as I know, there's no visual that would enable different/independent sorting in each column.