Data Visualization
Power BI · Data Visualization
Theory
Data visualization in Power BI means choosing the visual that answers the question fastest, then configuring it well. Start from the question, not the chart: a trend over time suits a line or column chart with dates on the axis; comparing categories suits a bar chart sorted by value; part-to-whole with few parts suits a stacked bar or a donut; a single headline number suits a card; exact values for lookup suit a table or matrix; and location suits a map.
For example, 'Which region sells most?' becomes a clustered bar chart with Region on the axis and [Total Sales] as the value, sorted descending, so North (₹3,200) appears first. Keep each visual focused on one message, label axes clearly, limit colours to what carries meaning, and avoid 3D effects or pies with many slices. Every visual on a page cross-filters the others by default, which you can tune with Edit interactions.
Why we use it
The same numbers can be clear or confusing depending on the visual. Good choices help readers see the answer in seconds and trust the report.
When to use it
Choose visuals once the measures are correct. Use tables and matrices when users need exact figures; use charts when the pattern matters more than the precise value. Consider custom visuals only when a built-in one cannot do the job.
How it works
- Business question
- Is it about change over time? Yes: Line or column chart with a date axis. No: Continue.
- Is it one headline number? Yes: Card or KPI visual. No: Continue.
- Do users need exact values? Yes: Table or matrix. No: Bar chart sorted by value.
- Format titles, labels and colours
Syntax
Report view → Visualizations pane → pick visual → drag fields into wells (X-axis, Y-axis, Legend, Values, Tooltips)
Format pane (paint brush) → titles, labels, colours
Format → Edit interactions → filter | highlight | noneExample
Building a 'Sales by Region' bar chart:
1. Click Clustered bar chart.
2. Y-axis: Sales[Region]; X-axis: [Total Sales].
3. More options (...) → Sort axis → Total Sales, descending.
4. Format → Data labels: On → North ₹3,200, West ₹2,400, South ₹600.
5. Title: 'Sales by Region'. Remove the legend (one series).Key points
- Start from the question, then choose the visual
- Line for trends, bar for comparisons, card for one number
- Tables and matrices when exact values matter
- Sort bars by value and add data labels sparingly
- Use Edit interactions to control cross-filtering between visuals