Skip to main content
Don’t miss what’s next at Microsoft Ignite
Don’t miss what’s next at Microsoft IgniteGet direct access to the people, products, and expertise behind Microsoft technology, with opportunities to ask questions, build skills, and learn alongside the community.
Register now
Microsoft
separator
https://catalogartifact.azureedge.net/publicartifacts/officesolution1640276900203.relative-value-evolution-radar-by-office-solution-0c08047e-d381-41b6-9286-3443481d7780/image0_relativevalueevolutionradarlogo.png

Relative Value Evolution Radar

by Office Solution AI Labs

Free Trial
Download SampleInstructions

Relative value & spread radar with historical play axis, motion trails, and benchmark overlay.

Relative Value & Spread Evolution Radar by Office Solution

The Relative Value & Spread Evolution Radar provides institutional-grade multi-factor comparison and spread tracking in Power BI. It plots multiple securities, strategies, or portfolios across polygonal radar spokes to evaluate relative valuation, risk metrics, liquidity, and performance factors simultaneously. Powered by an integrated chronological Play Axis engine, it brings static radar charts to life by animating shape migrations over time with fading historical lookback trails and directional vertex motion paths.

Key Concepts:

  • Multi-Dimensional Spoke Geometry: Compares instruments concurrently across 3 or more quantitative metrics (e.g., Z-Scores, Basis Spreads, Convexity, Carry, Liquidity).
  • Historical Evolution Trails: Renders fading historical polygon footprints and vertex trajectory paths across past observation periods to visualize how valuation profiles shift over time.
  • Dual Scaling Engine: Supports both Normalized (0–100%) mode to harmonize heterogeneous metrics (e.g., bp vs. ratios) on a single radar, and Raw / Absolute mode with spoke-specific min-max bounds.
  • Benchmark / Neutral Reference: Overlays an ideal peer-group target or neutral benchmark polygon with automated delta variance tracking.

Key Features:

  • Play Axis Playback & Timeline Scrubber: Play, pause, adjust playback speed (0.5x, 1x, 2x), enable looping, or use the interactive slider with step ticks to jump to any date or period.
  • Dynamic Toolbar Field Parameters: Place multiple columns into field wells (e.g., Sector, Ticker, or time granularities) to switch active dimensions directly from toolbar dropdowns on the fly.
  • Hierarchy Combination Mode: Automatically generates an "All Combined (Hierarchy)" option when multiple grouping fields are mapped to easily evaluate concatenated levels.
  • Dual Format Data Flexibility: Native support for both Long Format (Metric dimension + Value measure) and Wide Format (multiple numeric measure columns dragged directly into the Value well).
  • Interactive Vertex Marker Layer: Decoupled SVG rendering with top-level interactive dots and pass-through sheet fills, ensuring underlying dots and sheets are instantly hoverable without blocking.
  • Dynamic Series Z-Ordering: Hovering any dot or series automatically brings that series' sheet, glow outline, and vertices to the top of the visual stack while dimming background series.
  • Rich Boundary-Aware Tooltip: Displays instrument name, date, active metric, raw observed value, vs-benchmark delta, and normalized percentage with boundary clamping.
  • Interactive Series Legend: Click any series badge to toggle visibility (strike-through hide/show) and hover to isolate individual polygons.
  • Configurable Radar Aesthetics: Customize grid ring counts (3 to 10), polygon fill opacity, stroke thickness, trail lookback length, and theme colors.

Premium Features:

  • Interactive Play Axis Scrubber: Unlocks full playback controls, speed toggles, loop animation, and the chronological timeline scrubber.
  • Toolbar Field Parameter Switcher: Unlocks instant dimension and metric switching from the top toolbar dropdowns.
  • +Basic Features

Use Cases:

  • Fixed Income & Relative Value Trading: Compare sovereign and credit curves across OAS spread, butterfly convexity, 3M carry/roll, and cash-CDS basis.
  • Equity Factor & Style Profiling: Track portfolio factor exposures across Value, Quality, Momentum, Low Volatility, and Size across quarters.
  • Credit Derivatives & Arbitrage: Monitor synthetic CDX vs. cash bond spread discrepancies against benchmark curves over market cycles.
  • Multi-Asset Risk & Liquidity Monitoring: Evaluate liquidity risk scores, duration, beta, and Sharpe ratios across multi-asset funds.

Conclusion:

Transforms traditional static radar charts into dynamic, interactive analytical instruments for rigorous relative-value evaluation and time-series evolution tracking.

Note:

For more information, visit our website: https://innovationalofficesolution.com

Read more here: https://newwebsite.innovationalofficesolution.com/power-bi-charts/relative-value-evolution-radar

For any queries, questions, or requests, please write to us at: admin@innovationalofficesolution.com

Visual capabilities

This visual is certified by Power BI

At a glance

https://catalogartifact.azureedge.net/publicartifacts/officesolution1640276900203.relative-value-evolution-radar-by-office-solution-0c08047e-d381-41b6-9286-3443481d7780/image2_relativevalueevolutionradar1.png
/staticstorage/20261108.1/assets/videoOverlay_62a424ca921ff733.png
https://catalogartifact.azureedge.net/publicartifacts/officesolution1640276900203.relative-value-evolution-radar-by-office-solution-0c08047e-d381-41b6-9286-3443481d7780/image2_relativevalueevolutionradar1.png
https://catalogartifact.azureedge.net/publicartifacts/officesolution1640276900203.relative-value-evolution-radar-by-office-solution-0c08047e-d381-41b6-9286-3443481d7780/image3_relativevalueevolutionradar2.png
https://catalogartifact.azureedge.net/publicartifacts/officesolution1640276900203.relative-value-evolution-radar-by-office-solution-0c08047e-d381-41b6-9286-3443481d7780/image1_relativevalueevolutionradar3.png
https://catalogartifact.azureedge.net/publicartifacts/officesolution1640276900203.relative-value-evolution-radar-by-office-solution-0c08047e-d381-41b6-9286-3443481d7780/image4_relativevalueevolutionradar4.png
English (United States)
Your Privacy Choices Opt-Out Icon Your Privacy Choices
Consumer Health Privacy Sitemap Contact Us Privacy & Cookies Terms of Use About our ads Manage cookies