3 Unique Power BI Visuals You Probably Never Built Before

Visual #1 - Column Chart That Turns into a Line Chart

Problem

• Too many columns in a column chart when a big time period is chosen
• Line chart not suitable for small time frames

Solution

• Switching Chart: A column chart that becomes a line chart past a specific number of months

Key Steps

1. Combo Chart: Use a combination of a line and stacked column chart.
2. Two Measures Needed: One for the column series and one for the line series.
3. Calculations for Condition:
   • Minimum date of selected period
   • Maximum date of selected period
   • Number of months in the period
4. IF Condition:
   • If the month difference is less than 12, use year total sales for columns
   • If month difference is 12 or more, use year total sales for lines
5. Maximum Axis Synchronization:
   • Create a measure to calculate the maximum value for both primary and secondary y-axis using the MAXX function
   • Apply this measure as the maximum for both y-axes in formatting settings
6. Handling Blanks: For the column series, return 0 instead of blank to keep y-axis aligned

Fixes

• Ensure the maximums for both y-axes are in sync
• Turn off unwanted titles and values for cleaner look

Visual #2 - Fill Card Visual

Description

• A card visual showing KPIs with a filling background to represent completion percentage up to 100%

Key Steps

1. Create a Card Visual: Insert a new card visual
2. Measure for SVG Image:
   • Variable for fill percentage, fill color, empty color, width, height, and filled height
   • SVG code: Two rectangles representing filled and unfilled parts
3. Set Data Category: Set the measure’s data category to