Reference Lines
The Reference Lines feature in Powerviz heatmaps allows you to add horizontal or vertical lines to highlight specific thresholds or benchmarks within the heatmap. This helps in easily identifying critical values or trends, enhancing the overall data analysis.
Line Option
X-Axis and Y-Axis
At: Define the reference line based on Category Value or Ranking.
Category: Show all added category levels.
Ranking: Input the ranking number to position the reference line.
Line Style
Choose from Solid, Dashed, or Dotted.
Width: Set the width of the reference line.
Color: Choose the color for the reference line.
Line Position: Set the line position to Right, Center, or Left.
Label Styles
Label Name
Specify the name for the reference line label.
Color: Choose the color for the label text.
Background Color: Set the background color for the label.
Font Family: Choose the font family for the label text.
Styling: Apply Bold, Italic, or Underline.
Auto Font Size: Disable to set a manual font size.
Position
For X-Axis: Choose Right or Left.
For Y-Axis: Choose Top or Bottom.
X-Axis Alignment
Set alignment to Top, Center, or Bottom.
Orientation: Choose between Vertical and Horizontal.
Y-Axis Alignment
Set alignment to Right, Center, or Left.
Label Border
Border Radius
Choose the border-radius style: Sharp, Rounded, or Custom.
Width: Set the border width.
Border Color: Choose the color for the border.
Example
Last updated