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 Nerdywantocode
You can represent this scenario in multiple ways
1) One simple way to represent in a table where absolute value are display
where I have taken Month and product in Row
Department in Column
Sales in values
2) Dept wise Sales over a Month
3) Tree map but if yoh have less data in Product for each dept
It has Month, Dept, Product with Sales data.
This will not show you month on month trends for thrend analysis try below visual.
4) stacked column chart for month wise trend against different dept
X axis Month
Y axis Sales
Legends Product
Small multiple Dept
I hope this would give you an idea how to present your data using different visual.
I hope I answered your question!
Thanks a lot for those suggestions. I prefer a stacked column chart like your 2nd suggestion but I want to present department and sales . Could you see my latest post for more detail 😄
Hi Nerdywantocode
Try this chartCustom column chart
Or try thisor month on month comparison try this chart
I hope I answered your question!
Thanks, but how to present the department in the chart ?. I think it's only present product, sale and month, but missing the fourth criteria 😐