Forum Discussion
Power Bi Visualization Support
Hi Lachu1935,
It is great to hear you have conquered the hardest parts (DAX and Modeling). Moving from "Tables" to "Visuals" is actually a very fun transition because you already have the data ready to support it.
Since you are in the Retail sector managing multiple brands (Skechers, Manyavar, etc.) and 40 stores, you have the perfect dataset for storytelling.
Here is a roadmap to help you level up your visualization skills:
1. Inspiration First: The Data Stories Gallery Before you build, look at what is possible. The Microsoft Community has a gallery where users post their best reports. Filter by "Sales" or "Retail" to see how others visualize store performance.
2. The "Retail" Cheat Sheet For your specific case, try moving away from huge tables by using these visuals:
Map Visual: You have 40 stores. Plot them on a map with bubble sizes representing "Sales Amount".
Small Multiples: Since you have different brands, try using a Line Chart with "Small Multiples" on the Brand field. This will create separate mini-charts for Skechers, Zimson, etc., in one view without clutter.
Bar Charts with Drill Down: Show "Total Sales by Brand," and let users drill down into "Store Level."
3. Learning Resources Microsoft Learn has a specific learning path for this. It covers not just "how" to create a chart, but "which" chart to choose.
Course: Design Power BI reports
My advice: Pick one page of your current report that is just a big table. Try to replace it with 3 visuals (A KPI Card for Total Sales, a Trend Line for history, and a Bar Chart for store comparison).
Good luck on your design journey!
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful. This response was assisted by AI for translation and formatting purposes.
Super UserHi Lachu1935,
It is great to hear you have conquered the hardest parts (DAX and Modeling). Moving from "Tables" to "Visuals" is actually a very fun transition because you already have the data ready to support it.
Since you are in the Retail sector managing multiple brands (Skechers, Manyavar, etc.) and 40 stores, you have the perfect dataset for storytelling.
Here is a roadmap to help you level up your visualization skills:
1. Inspiration First: The Data Stories Gallery Before you build, look at what is possible. The Microsoft Community has a gallery where users post their best reports. Filter by "Sales" or "Retail" to see how others visualize store performance.
2. The "Retail" Cheat Sheet For your specific case, try moving away from huge tables by using these visuals:
Map Visual: You have 40 stores. Plot them on a map with bubble sizes representing "Sales Amount".
Small Multiples: Since you have different brands, try using a Line Chart with "Small Multiples" on the Brand field. This will create separate mini-charts for Skechers, Zimson, etc., in one view without clutter.
Bar Charts with Drill Down: Show "Total Sales by Brand," and let users drill down into "Store Level."
3. Learning Resources Microsoft Learn has a specific learning path for this. It covers not just "how" to create a chart, but "which" chart to choose.
Course: Design Power BI reports
My advice: Pick one page of your current report that is just a big table. Try to replace it with 3 visuals (A KPI Card for Total Sales, a Trend Line for history, and a Bar Chart for store comparison).
Good luck on your design journey!
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful. This response was assisted by AI for translation and formatting purposes.
Really useful, thank you
- burakkaragoz
You are very welcome Lachu1935 !
I am glad to hear the roadmap was useful. Visualization is all about experimentation, so don't be afraid to play around with those Small Multiples for your brand comparisons. It really is a game-changer for retail data.
If you have a moment, please mark the post as the Accepted Solution. This will help others in the community find these design tips quickly.
Happy designing!