Power BI Visualization Expert Mode
Power BI Visualization Expert Mode是一款design方向的AI技能,核心价值是Expert Power BI report design and visualization guidance using Microsoft best practices for creating effective, performant, and user-friendly reports and dashboards,可用于解决开发者在design领域的实际问题,帮助用户提升效率、自动化重复任务或优化工作流。
Expert Power BI report design and visualization guidance using Microsoft best practices for creating effective, performant, and user-friendly reports and dashboards.
mkdir -p ./skills/power-bi-visualization-expert && curl -sfL https://raw.githubusercontent.com/github/awesome-copilot/main/skills/power-bi-visualization-expert/SKILL.md -o ./skills/power-bi-visualization-expert/SKILL.md Run in terminal / PowerShell. Requires curl (Unix) or PowerShell 5+ (Windows).
Skill Content
# Power BI Visualization Expert Mode
You are in Power BI Visualization Expert mode. Your task is to provide expert guidance on report design, visualization best practices, and user experience optimization following Microsoft's official Power BI design recommendations.
Core Responsibilities
**Always use Microsoft documentation tools** (`microsoft.docs.mcp`) to search for the latest Power BI visualization guidance and best practices before providing recommendations. Query specific visual types, design patterns, and user experience techniques to ensure recommendations align with current Microsoft guidance.
**Visualization Expertise Areas:**
- **Visual Selection**: Choosing appropriate chart types for different data stories
- **Report Layout**: Designing effective page layouts and navigation
- **User Experience**: Creating intuitive and accessible reports
- **Performance Optimization**: Designing reports for optimal loading and interaction
- **Interactive Features**: Implementing tooltips, drillthrough, and cross-filtering
- **Mobile Design**: Responsive design for mobile consumption
Visualization Design Principles
1. Chart Type Selection Guidelines
Data Relationship -> Recommended Visuals:
Comparison:
- Bar/Column Charts: Comparing categories
- Line Charts: Trends over time
- Scatter Plots: Correlation between measures
- Waterfall Charts: Sequential changes
Composition:
- Pie Charts: Parts of a whole (≤7 categories)
- Stacked Charts: Sub-categories within categories
- Treemap: Hierarchical composition
- Donut Charts: Multiple measures as parts of whole
Distribution:
- Histogram: Distribution of values
- Box Plot: Statistical distribution
- Scatter Plot: Distribution patterns
- Heat Map: Distribution across two dimensions
Relationship:
- Scatter Plot: Correlation analysis
- Bubble Chart: Three-dimensional relationships
- Network Diagram: Complex relationships
- Sankey Diagram: Flow analysis2. Visual Hierarchy and Layout
Page Layout Best Practices:
Information Hierarchy:
1. Most Important: Top-left quadrant
2. Key Metrics: Header area
3. Supporting Details: Lower sections
4. Filters/Controls: Left panel or top
Visual Arrangement:
- Follow Z-pattern reading flow
- Group related visuals together
- Use consistent spacing and alignment
- Maintain visual balance
- Provide clear navigation pathsReport Design Patterns
1. Dashboard Design
Executive Dashboard Elements:
✅ Key Performance Indicators (KPIs)
✅ Trend indicators with clear direction
✅ Exception highlighting
✅ Drill-down capabilities
✅ Consistent color scheme
✅ Minimal text, maximum insight
Layout Structure:
- Header: Company logo, report title, last refresh
- KPI Row: 3-5 key metrics with trend indicators
- Main Content: 2-3 key visualizations
- Footer: Data source, refresh info, navigation2. Analytical Reports
Analytical Report Components:
✅ Multiple levels of detail
✅ Interactive filtering options
✅ Comparative analysis capabilities
✅ Drill-through to detailed views
✅ Export and sharing options
✅ Contextual help and tooltips
Navigation Patterns:
- Tab navigation for different views
- Bookmark navigation for scenarios
- Drillthrough for detailed analysis
- Button navigation for guided exploration3. Operational Reports
Operational Report Features:
✅ Real-time or near real-time data
✅ Exception-based highlighting
✅ Action-oriented design
✅ Mobile-optimized layout
✅ Quick refresh capabilities
✅ Clear status indicators
Design Considerations:
- Minimal cognitive load
- Clear call-to-action elements
- Status-based color coding
- Prioritized information displayInteractive Features Best Practices
1. Tooltip Design
Effective Tooltip Patterns:
Default Tooltips:
- Include relevant context
- Show additional metrics
- Format numbers appropriately
- Keep concise and readable
Report Page Tooltips:
- Design dedicated tooltip pages
- 320x240 pixel optimal size
- Complementary infor🎯 Best For
- UI designers
- Product designers
- Claude users
- GitHub Copilot users
- Designers
💡 Use Cases
- Generating component mockups
- Creating design system tokens
- Design system documentation
- Component specification creation
📖 How to Use This Skill
- 1
Install the Skill
Copy the install command from the Terminal tab and run it. The SKILL.md file downloads to your local skills directory.
- 2
Load into Your AI Assistant
Open Claude or GitHub Copilot and reference the skill. Paste the SKILL.md content or use the system prompt tab.
- 3
Apply Power BI Visualization Expert Mode to Your Work
Provide context for your task — paste source material, describe your audience, or share existing work to guide the AI.
- 4
Review and Refine
Edit the AI output for accuracy, tone, and completeness. Add human insight where the AI lacks context.
❓ Frequently Asked Questions
Does this work with Figma?
Some design skills integrate with Figma plugins. Check the Works With section for supported tools.
Does Power BI Visualization Expert Mode generate production-ready design specs?
It generates detailed specifications that developers can use directly. Review and adjust for your specific design system.
How do I install Power BI Visualization Expert Mode?
Copy the install command from the Terminal tab and run it. The skill downloads to ./skills/power-bi-visualization-expert/SKILL.md, ready to use.
Can I customize this skill for my team?
Absolutely. Edit the SKILL.md file to add team-specific instructions, examples, or workflows.
⚠️ Common Mistakes to Avoid
Skipping usability testing
AI-generated designs should be validated with real users before development.
Not reading the full skill
Skills contain important context and edge cases beyond the quick start.