How to deal with clustered column chart with multiple columns data?

[DXJ_JEFFREY]

I got one complicated lists with over 50 columns like p2.1,p2.2,p2.3......., I want to show the average data in clustered column chart, when I put the data in, it seems slim and concentrated, not the graphic I wanted, can somebody help on this, how to deal with this situation. by the way, my list is in microsoft LISTS, it will be complicated if i transfer the data by POWER QUERY unpivot. i want to keep the data as is. thanks.

[raji_n]

@DXJ_JEFFREY if my post solved your issue, please mark it as a solution, so that others can also refer this solution 🙂

[raji_n]

@DXJ_JEFFREY if my post solved your issue, please mark it as a solution, so that others can also refer this solution 🙂

[raji_n · Accepted solution]

Clustered column charts are not suitable for visuals having more than 5 metrics to be shown together, I would suggest you preselect some of them or go for alternative visuals. @DXJ_JEFFREY 

How about small multiples chart?