Forum Discussion
Get help in creating a suitable visulization
Nerdywantocode
This is the functionality of a regular stacked/clustered column graph :I attached a pbix with one of the examples, you can follow the steps 🙂
Hi Guys, thanks all for the solution. Sorry for not giving sample data. Here is sample data look like:
I think i might use a stacked column chart like this. But I'm having trouble in making those column stack with each other for each month. Can someone help me to fix this:
Regards,
Hi Nerdywantocode
What exactly do you want on stack column chart??
Can you high light something wht do you want ???The column is the number of sales of each product, stacked each other. The x axis represent department sale those product, and then detail for each month. The problem I want those column stick with other for each department like cluster column chart
Hi Nerdywantocode
If the goal of the graph is to be readable and effective in conveying messages of comparison, a stacked bar chart is a poor choice, to say the least. I have attached a link to 2 articles that explain the problems more or less:https://www.madeiradata.com/post/home-experiments-and-stacked-bar-graphs
my personal recommendation, if you want to go to the columns graph direction, is to use small multiples .
something like these:If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Could you show me the name of the visual 😐
Nerdywantocode
This is the functionality of a regular stacked/clustered column graph :I attached a pbix with one of the examples, you can follow the steps 🙂