Coconote
AI notes
AI voice & video notes
Export note
Try for free
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
Combo Chart
: Use a combination of a line and stacked column chart.
Two Measures Needed
: One for the column series and one for the line series.
Calculations for Condition
:
Minimum date of selected period
Maximum date of selected period
Number of months in the period
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
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
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
Create a Card Visual
: Insert a new card visual
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
Set Data Category
: Set the measure’s data category to
📄
Full transcript