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 🙂
It is very difficult to answer such a question without delving into the data itself and a precise specification that includes the exact goals of the requested report and what exactly will be done with each number that appears in it + how many products and departments exactly exist to understand the required layout.
But I will try to give the general direction, the only visualization that allows you to easily see a combination of several metrics and is easy to read is a matrix/combined table in the case you described, probably the metrics will be at the department and product level when the order of the hierarchy between them depends on the main need, whether you check each department separately and measure the products or for each product you check which department has good performance and which department needs to improve.
The metrics:
Total sales for the department (with a bar graph of ranking like in picture 1)
3-month trend line/small columns (like in picture 2)
Maybe the percentage change from the beginning of the measurement/other historical period with alerts using a red circle in case of decreases (picture 3)
And so on as needed...
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thank you for your idea, but it's look like it's not suitable for a pdf report. I think it's should work well for a dashboard report, but my lead dont want that 😞
