Power BI Custom Visual - DualCard

Dual card is a Power BI custom visual to compare two measures. Visual provides advanced formatting options.Visual requires two measures.
First measure is referred as data and second one referred as comparison measure.

Formatting Options

Card Type

Card Type sets orientation of the card.
 Options:
        • Horizontal: Splits card horizontally. Top pane shows data and bottom pane shows comparison measure.
        • Vertical: Splits card vertically. Right pane shows data and left pane shows comparison measure.

Data Fill

Formatting options for filling data pane.
 Options:
         • Flag: Flag to turn data pane fill on or off.
         • Fill Type: Options to fill color with Solid or Blur effects.
         • Fill Color: Data fill color.
             Note: Fill color is ignored when conditional formatting is on.
         • X Position: Start position for data fill.
         • Y Position: End position for data fill.
         • Fill Width: Data fill width specified as %.
         • Fill Height: Data fill height specified as %.
         • Conditional Formatting: Flag for conditional formatting.
             • Min: Minimum range for conditional formatting.
             • Min Color: Fill color for minimum range.
             • Mid: Mid range for conditional formatting.
             • Mid Color: Fill color for mid range.
             • Max: Max range for conditional formatting.
             • Max Color: Fill color for max range.

Data Label

Formatting options for data/measure label/value.
 Options:
         • Font Family: Font family for data label.
         • Font Size: Font size for data label.
             NOTE: While setting larger font size, manually adjust card size to avoid overlapping or truncation.
         • Font Color: Data label color.
             NOTE: Data label color is ignored when conditional formatting is on.
         • Fill Bold: Option to set font normal or bold.
         • Display Units: Display format for data label.
            Options to format and display measure in Thousands, Millions, Billions or Trillions.
            Setting none displays numeric value. Setting Auto will determine runtime and formats as Thousands, Millions, Billions or Trillions.
         • Decimal Places: Decimal precision settings for data label.
         • Alignment: Predefined alignment of data label.
            Options are Top Left, Top Middle, Top Right, Mid Left, Mid Center, Mid Right, Bottom Left, Bottom Center, Bottom Right.
         • Position: Flag to position data label. Data label will be placed based on X & Y coordinates.
             NOTE: Setting position on, ignores alignment.
                         While positioning near boundaries, visual automaticy adjusts label to avoid overrun or truncation.
         • X Position: X coordinate to place data label. Specified as % value.
         • Y Position: Y coordinate to place data label. Specified as % value.
         • Conditional Formatting: Flag for data label conditional formatting.
             • Min: Minimum data range for data label conditional formatting.
             • Min Color: Fill color for minimum range.
             • Mid: Mid data range for conditional formatting.
             • Mid Color: Fill color for mid range.
             • Max: Max data range for conditional formatting.
             • Max Color: Fill color for max range.

Data Category

Formatting options for data/measure category.
 Options:
         • Font Family: Font family for data category.
         • Font Size: Font size for data category.
             NOTE: While setting larger font size, manually adjust card size to avoid overlapping or truncation.
         • Font Color: Data category color.
             NOTE: Data category color is ignored when conditional formatting is on.
         • Fill Bold: Option to set font normal or bold.
         • Display Units: Display format for data category.
            Options to format and display measure in Thousands, Millions, Billions or Trillions.
            Setting none displays numeric value. Setting Auto will determine runtime and formats as Thousands, Millions, Billions or Trillions.
         • Decimal Places: Decimal precision settings for data category.
         • Alignment: Predefined alignment of data category.
            Options are Top Left, Top Middle, Top Right, Mid Left, Mid Center, Mid Right, Bottom Left, Bottom Center, Bottom Right.
         • Position: Flag to position data category. Data category will be placed based on X & Y coordinates.
             NOTE: Setting position on, ignores alignment.
                         While positioning near boundaries, visual automaticy adjusts category to avoid overrun or truncation.
         • X Position: X coordinate to place data category. Specified as % value.
         • Y Position: Y coordinate to place data category. Specified as % value.
         • Conditional Formatting: Flag for data category conditional formatting.
             • Min: Minimum data range for data category conditional formatting.
             • Min Color: Fill color for minimum range.
             • Mid: Mid data range for conditional formatting.
             • Mid Color: Fill color for mid range.
             • Max: Max data range for conditional formatting.
             • Max Color: Fill color for max range.

Comp Fill

Formatting options for filling comparison measure pane.
 Options:
         • Flag: Flag to turn comp pane fill on or off.
         • Fill Type: Options to fill color with Solid or Blur effects.
         • Fill Color: Comparison pane fill color.
             Note: Fill color is ignored when conditional formatting is on.
         • X Position: Start position for comp fill.
         • Y Position: End position for comp fill.
         • Fill Width: Comp fill width specified as %.
         • Fill Height: Comp fill height specified as %.
         • Conditional Formatting: Flag for conditional formatting.
             • Min: Minimum range for conditional formatting.
             • Min Color: Fill color for minimum range.
             • Mid: Mid range for conditional formatting.
             • Mid Color: Fill color for mid range.
             • Max: Max range for conditional formatting.
             • Max Color: Fill color for max range.

Comp Label

Formatting options for comparison measure label/value.
 Options:
         • Font Family: Font family for comparison measure label.
         • Font Size: Font size for comparison measure label.
             NOTE: While setting larger font size, manually adjust card size to avoid overlapping or truncation.
         • Font Color: Comparison measure color.
             NOTE: Comparison measure color is ignored when conditional formatting is on.
         • Fill Bold: Option to set font normal or bold.
         • Display Units: Display format for comparison measure label.
            Options to format and display measure in Thousands, Millions, Billions or Trillions.
            Setting none displays numeric value. Setting Auto will determine runtime and formats as Thousands, Millions, Billions or Trillions.
         • Decimal Places: Decimal precision settings for comparison measure label.
         • Alignment: Predefined alignment of comparison measure label.
            Options are Top Left, Top Middle, Top Right, Mid Left, Mid Center, Mid Right, Bottom Left, Bottom Center, Bottom Right.
         • Position: Flag to position comparison measure label. Comparison measure label will be placed based on X & Y coordinates.
             NOTE: Setting position on, ignores alignment.
                         While positioning near boundaries, visual automaticy adjusts label to avoid overrun or truncation.
         • X Position: X coordinate to place comparison measure label. Specified as % value.
         • Y Position: Y coordinate to place comparison measure label. Specified as % value.
         • Conditional Formatting: Flag for comparison measure label conditional formatting.
             • Min: Minimum range for comparison measure label conditional formatting.
             • Min Color: Fill color for minimum range.
             • Mid: Mid range for conditional formatting.
             • Mid Color: Fill color for mid range.
             • Max: Max range for conditional formatting.
             • Max Color: Fill color for max range.

Comp Category

Formatting options for comparison measure category.
 Options:
         • Font Family: Font family for comparison measure category.
         • Font Size: Font size for comparison measure category.
             NOTE: While setting larger font size, manually adjust card size to avoid overlapping or truncation.
         • Font Color: Comparison measure category color.
             NOTE: comparison measure category color is ignored when conditional formatting is on.
         • Fill Bold: Option to set font normal or bold.
         • Display Units: Display format for data category.
            Options to format and display measure in Thousands, Millions, Billions or Trillions.
            Setting none displays numeric value. Setting Auto will determine runtime and formats as Thousands, Millions, Billions or Trillions.
         • Decimal Places: Decimal precision settings for comparison measure category.
         • Alignment: Predefined alignment of comparison measure category.
            Options are Top Left, Top Middle, Top Right, Mid Left, Mid Center, Mid Right, Bottom Left, Bottom Center, Bottom Right.
         • Position: Flag to position comparison measure category. Data category will be placed based on X & Y coordinates.
             NOTE: Setting position on, ignores alignment.
                         While positioning near boundaries, visual automaticy adjusts category to avoid overrun or truncation.
         • X Position: X coordinate to place comparison measure category. Specified as % value.
         • Y Position: Y coordinate to place comparison measure category. Specified as % value.
         • Conditional Formatting: Flag for comparison measure category conditional formatting.
             • Min: Minimum data range for comparison measure category conditional formatting.
             • Min Color: Color for minimum range.
             • Mid: Mid range for conditional formatting.
             • Mid Color: Color for mid range.
             • Max: Max range for conditional formatting.
             • Max Color: Color for max range.

Close Menu