Need Help with Data Modelling

[Kishore_Sr4]

Hello, I have two Product columns one is Own product and other one is Competitor product. So they were testing the own product vs competitor based on several attributes such as Taste, Aroma, Appearence and 100 more each in one Columns and give ratings from 1 to 5;

• 1= definitelly too weak; 2= somewhat too weak; 3= Jast about right; 4 =somewhat too strong, 5= definitelly too strong
• Usualy presented as bar diagrams, from left side % of too weak (combined 1 and 2 answers)% of JAR, % of too strong (combined 4 and 5 answers)
• 

  For Each Test they assign Test_ID, each Test_ID is tested with about 200 members and so 200 rows for each Test_ID, Now I have to aggregate data for each Test_ID along with % count of each attributes and present the data as bar diagram as I shown above

• Can someone help me to achieve this please....Thank You..!!

[amitchandak]

@Kishore_Sr4 , if you looking for a similar diagram, I doubt that. You can check custom visual

You can try stacked with small mutiple and can help

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.