Forum Discussion
Helper IStacked Bar chart: Group legend values
Lanceometer - The stacked bar is absolutely the wrong choice of visual for this number of products. Besides the fact it's not showing all of them, there's absolutely no way your users will be able to establish what any of this means.
There's also not really any way you SHOULD fix this with DAX.
Perhaps this needs to be two visuals one with Month on the X-axis, the other with Product, you can then use an interaction between the two charts to allow users to see how each product sold within a month.
Or, if you need both in the same visual, I suggest using a matrix to create a heat map. Place Product in the rows and month in the columns, then use conditional formatting on the values to show the highest and lowest.
If this helps, please accept as the solution, it helps others with the same challenge.
Super UserLanceometer - The stacked bar is absolutely the wrong choice of visual for this number of products. Besides the fact it's not showing all of them, there's absolutely no way your users will be able to establish what any of this means.
There's also not really any way you SHOULD fix this with DAX.
Perhaps this needs to be two visuals one with Month on the X-axis, the other with Product, you can then use an interaction between the two charts to allow users to see how each product sold within a month.
Or, if you need both in the same visual, I suggest using a matrix to create a heat map. Place Product in the rows and month in the columns, then use conditional formatting on the values to show the highest and lowest.
If this helps, please accept as the solution, it helps others with the same challenge.