Because there are just too many records that you're trying to visualize and when you squeeze them into a single view the bars overlap and appears to be greyed out. Try to minimize number of records you're trying to visualize to fit in the single view.
Hope this helps.
Hi Alexander, it is important to note the difference between a bar chart and pareto chart. Pareto chart is plotted using running totals which are continuous values that follow a growth path. Hence, when you plot them and view them in single view, although the data is so densely packed it looks normal due to the running totals. A Pareto Chart can only have 1 dimension and at least 1 measure.
However, in your bar chart you're trying to plot "Average Profitability" for each "Brand/Description". That means each combination of these two dimensions would have its own discrete "Average Profitability" value.
Here's how it looks when I take one dimension out and do a "Running Total" of "Average Profitability".
Hope this helps. Let me know if you have questions.
Thank you Shiva!
So does your visualization show the running sum of average profitability with good with the highest profitability at the left? Is there no way of showing the average profitability similar to this without summing it up?
Could you post the twbx file?