3 Unique Power BI Visuals

Jul 4, 2024

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