{"id":53384,"date":"2025-09-12T09:48:16","date_gmt":"2025-09-12T04:48:16","guid":{"rendered":"https:\/\/chartexpo.com\/blog\/?p=53384"},"modified":"2025-11-18T10:51:32","modified_gmt":"2025-11-18T05:51:32","slug":"slowly-changing-dimensions","status":"publish","type":"post","link":"https:\/\/chartexpo.com\/blog\/slowly-changing-dimensions","title":{"rendered":"Slowly Changing Dimensions: Insight and Visual Made Easy"},"content":{"rendered":"<p>Data doesn\u2019t sit still. Businesses grow. Customers move. Job roles shift. Behind every change is a story. But if your system can\u2019t remember what came before, that story vanishes. That\u2019s where slowly changing dimensions come in.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-main.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-main.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQklNQUM4OTUrTXVsdGlBeGlzTGluZUNoYXJ0Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/> <\/a> <a href=\" https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTg5NSs=\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTg5NSs=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<p>In the data warehouse, these changes matter. A small update\u2014like a job promotion or address change\u2014could hold big meaning down the road. But if you overwrite the past, your analysis loses its depth. Slowly changing dimensions keep that history alive.<\/p>\n<p>This guide explains how slowly changing dimensions work. We\u2019ll break down each type, show you real examples, and walk through how to use them in Power BI.<\/p>\n<p>You\u2019ll learn how to structure your tables, build smart visualizations, and keep your historical data accurate and useful. You don\u2019t need to be an engineer. You just need a plan.<\/p>\n<style>\n  .toc-container {<br \/>    max-width: 100%;<br \/>    font-family: Arial, sans-serif;<br \/>  }<\/p>\n<p>  .toc-list {<br \/>    list-style: none;<br \/>    padding: 0;<br \/>  }<\/p>\n<p>  .toc-list li {<br \/>    font-size: 16px;<br \/>    line-height: 1.5;<br \/>    word-wrap: break-word;<br \/>    overflow-wrap: break-word;<br \/>    max-width: 100%;<br \/>    margin-bottom: 8px;<br \/>  }<\/p>\n<p>  .toc-list li a {<br \/>    text-decoration: none;<br \/>    color: #0073aa;<br \/>  }<\/p>\n<\/style>\n<div class=\"toc-container\">\n<h3>Table of Contents:<\/h3>\n<ol class=\"toc-list\">\n<li><a href=\"#what-are-slowly-changing-dimensions-scd\">What are Slowly Changing Dimensions (SCD)?<\/a><\/li>\n<li><a href=\"#why-are-scds-important\">Why are SCDs important?<\/a><\/li>\n<li><a href=\"#explain-the-slowly-changing-dimensions-types\">Explain the Slowly Changing Dimensions Types<\/a><\/li>\n<li><a href=\"#explaining-the-slowly-changing-dimensions-examples\">Explaining the Slowly Changing Dimensions Examples<\/a><\/li>\n<li><a href=\"#how-to-create-an-scd-table\">How to create an SCD Table?<\/a><\/li>\n<li><a href=\"#how-to-implement-slowly-changing-dimensions-in-power-bi\">How to Implement Slowly Changing Dimensions in Power BI?<\/a><\/li>\n<li><a href=\"#techniques-for-maintaining-slowly-changing-dimensions\">Techniques for Maintaining Slowly Changing Dimensions<\/a><\/li>\n<li><a href=\"#benefits-of-slowly-changing-dimensions-type-2\">Benefits of Slowly Changing Dimensions Type 2<\/a><\/li>\n<li><a href=\"#tips-for-using-slowly-changing-dimensions\">Tips for Using Slowly Changing Dimensions<\/a><\/li>\n<li><a href=\"#limitations-of-slowly-changing-dimensions\">Limitations of Slowly Changing Dimensions<\/a><\/li>\n<li><a href=\"#faqs\">FAQs<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap-up<\/a><\/li>\n<\/ol>\n<\/div>\n<h2 id=\"what-are-slowly-changing-dimensions-scd\">What are Slowly Changing Dimensions (SCD)?<\/h2>\n<p><strong>Definition: Slowly changing dimensions<\/strong> are fields in a dimension table that change over time but not often. Think of customer addresses, employee roles, or product categories. These details shift slowly, but when they do, the history matters.<\/p>\n<p>In a data warehouse, this structure usually includes a <a href=\"https:\/\/chartexpo.com\/blog\/fact-table-vs-dimension-table\" target=\"_blank\" rel=\"noopener\">fact table vs a dimension table<\/a> setup. Facts hold the numbers\u2014sales, transactions, or quantities. Dimensions give context\u2014names, locations, dates.<\/p>\n<p>Let\u2019s say Sarah moves from Austin to Houston. You can\u2019t just update her record. That change has value. Maybe her purchases increased after the move. That\u2019s insight you lose if the system forgets her Austin days. Slowly changing dimensions solve that. They give you a clean, organized way to track updates.<\/p>\n<h2 id=\"why-are-scds-important\">Why are SCDs important?<\/h2>\n<p>Without history, data is empty. That\u2019s why slowly changing dimensions are critical.<\/p>\n<p>They let you keep a timeline. You can see where customers started, what changed, and when. That\u2019s essential for analysis. Whether you&#8217;re comparing current performance or spotting trends, knowing what came before gives you the edge.<\/p>\n<p>They also help with data accuracy. You don\u2019t overwrite valuable changes. Instead, you build on them. This structure supports <a href=\"https:\/\/chartexpo.com\/blog\/data-analysis\" target=\"_blank\" rel=\"noopener\">data analysis<\/a> with layers of meaning\u2014past, present, and future all in one place.<\/p>\n<p>And if you need to prove something for an audit or backtrack on a decision, that history is right there. You\u2019re not guessing\u2014you\u2019re reporting with confidence.<\/p>\n<h2 id=\"explain-the-slowly-changing-dimensions-types\">Explain the Slowly Changing Dimensions Types<\/h2>\n<p>There are five slow-changing dimension types, each offering a way to manage history.<\/p>\n<p><strong>Type 0: Retain Original<\/strong><\/p>\n<ul>\n<li>You never change the data. Whatever goes in first stays forever. Use it for static values like national ID numbers.<\/li>\n<\/ul>\n<p><strong>Type 1: Overwrite Changes<\/strong><\/p>\n<ul>\n<li>You replace old values. No history kept. It\u2019s quick and simple, but it forgets what came before.<\/li>\n<\/ul>\n<p><strong>Type 2: Add New Row<\/strong><\/p>\n<ul>\n<li>You add a new row every time something changes. Each version has metadata like effective dates and status flags. This type gives you full history and is the most detailed method.<\/li>\n<\/ul>\n<p><strong>Type 3: Add New Column<\/strong><\/p>\n<ul>\n<li>Instead of new rows, you add columns for old and new values. This works well when you only need to see the latest change.<\/li>\n<\/ul>\n<p><strong>Type 4: Historical Table<\/strong><\/p>\n<ul>\n<li>You keep one table for current data and another table for history. It separates the now from the past, reducing clutter but requiring more structure.<\/li>\n<\/ul>\n<p>Each type serves a purpose. Pick the one that fits your tracking goals and system limits.<\/p>\n<h2 id=\"explaining-the-slowly-changing-dimensions-examples\">Explaining the Slowly Changing Dimensions Examples<\/h2>\n<p>Examples make these types real.<\/p>\n<p><strong>Type 0:<\/strong><\/p>\n<ul>\n<li>Sarah\u2019s national ID is CNIC 35202-xxxxxxx-x. Even if she updates her profile, that ID never changes.<\/li>\n<\/ul>\n<p><strong>Type 1:<\/strong><\/p>\n<ul>\n<li>Sarah Khan becomes Sarah Ali. The old name is gone, replaced. No record of Sarah Khan remains.<\/li>\n<\/ul>\n<p><strong>Type 2:<\/strong><\/p>\n<ul>\n<li>Sarah gets promoted from Analyst to Manager. A new row is added. One row says she was an Analyst (now inactive), the other shows her current Manager role.<\/li>\n<\/ul>\n<table class=\"static\" style=\"table-layout: fixed; border-collapse: collapse; width: 100%; font-size: 17px; border: 1px solid #ccc;\">\n<thead>\n<tr>\n<td style=\"text-align: center;\"><strong>ID<\/strong><\/td>\n<td style=\"text-align: center;\"><strong>Emp_Name<\/strong><\/td>\n<td style=\"text-align: center;\"><strong>Role<\/strong><\/td>\n<td style=\"text-align: center;\"><strong>Start_Date<\/strong><\/td>\n<td style=\"text-align: center;\"><strong>End_Date<\/strong><\/td>\n<td style=\"text-align: center;\"><strong>Is_Current<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>101<\/td>\n<td>Sarah<\/td>\n<td>Analyst<\/td>\n<td>2023-01-01<\/td>\n<td>2024-06-01<\/td>\n<td>FALSE<\/td>\n<\/tr>\n<tr>\n<td>102<\/td>\n<td>Sarah<\/td>\n<td>Manager<\/td>\n<td>2024-06-01<\/td>\n<td>NULL<\/td>\n<td>TRUE<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Type 3:<\/strong><\/p>\n<ul>\n<li>Sarah moves from Austin to Houston. The system adds a column for the previous city.<\/li>\n<\/ul>\n<table class=\"static\" style=\"table-layout: fixed; border-collapse: collapse; width: 100%; font-size: 17px; border: 1px solid #ccc;\">\n<thead>\n<tr>\n<td style=\"text-align: center;\"><strong>Cust_ID<\/strong><\/td>\n<td style=\"text-align: center;\"><strong>Cust_Name<\/strong><\/td>\n<td style=\"text-align: center;\"><strong>Current_City<\/strong><\/td>\n<td style=\"text-align: center;\"><strong>Previous_City<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>501<\/td>\n<td>Sarah<\/td>\n<td>Houston<\/td>\n<td>Austin<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Type 4:<\/strong><\/p>\n<ul>\n<li>The main table has the current city. A separate history table logs all past cities and dates.<\/li>\n<\/ul>\n<p>Main Table (Customer):<\/p>\n<table class=\"static\" style=\"table-layout: fixed; border-collapse: collapse; width: 100%; font-size: 17px; border: 1px solid #ccc;\">\n<tbody>\n<tr>\n<td style=\"text-align: center;\" width=\"78\"><strong>Cust_ID<\/strong><\/td>\n<td style=\"text-align: center;\" width=\"61\"><strong>Name<\/strong><\/td>\n<td style=\"text-align: center;\" width=\"124\"><strong>City<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"78\">501<\/td>\n<td width=\"61\">Sarah<\/td>\n<td width=\"124\">Houston<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>History Table (Customer_History):<\/p>\n<table class=\"static\" style=\"table-layout: fixed; border-collapse: collapse; width: 100%; font-size: 17px; border: 1px solid #ccc;\">\n<tbody>\n<tr>\n<td style=\"text-align: center;\"><strong>Cust_ID<\/strong><\/td>\n<td style=\"text-align: center;\"><strong>Name<\/strong><\/td>\n<td style=\"text-align: center;\"><strong>City<\/strong><\/td>\n<td style=\"text-align: center;\"><strong>Effective_Date<\/strong><\/td>\n<\/tr>\n<tr>\n<td>501<\/td>\n<td>Sarah<\/td>\n<td>Houston<\/td>\n<td>2022-01-01<\/td>\n<\/tr>\n<tr>\n<td>501<\/td>\n<td>Sarah<\/td>\n<td>Austin<\/td>\n<td>2023-03-01<\/td>\n<\/tr>\n<tr>\n<td>501<\/td>\n<td>Sarah<\/td>\n<td>San Diego<\/td>\n<td>2024-06-01<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"how-to-create-an-scd-table\">How to create an SCD Table?<\/h2>\n<p><strong>SCD tables<\/strong> are how you track change without losing your base. You build them with a few smart choices.<\/p>\n<p><strong>Find Dimension Attributes That May Vary With Time<\/strong><\/p>\n<ul>\n<li>Choose fields that change but matter\u2014like job title or city. Skip fixed data like birthdates.<\/li>\n<\/ul>\n<p><strong>Insert SCD Type 2 Metadata Columns<\/strong><\/p>\n<ul>\n<li>Add surrogate_key, start_date, end_date, and is_current_flag. These fields track changes and keep the history in place.<\/li>\n<\/ul>\n<p><strong>ETL Workflow Design<\/strong><\/p>\n<ul>\n<li>Your data pipeline should compare new and old data. Based on the result, insert, update, or skip the row. Match your logic to the SCD type.<\/li>\n<\/ul>\n<p><strong>Load To the Data Warehouse<\/strong><\/p>\n<ul>\n<li>Use tools like SSIS, Apache NiFi, or SQL scripts. Keep updates clean\u2014no duplicates, no lost history.<\/li>\n<\/ul>\n<p>Done right, this setup keeps your timeline sharp.<\/p>\n<h2 id=\"how-to-implement-slowly-changing-dimensions-in-power-bi\">How to Implement Slowly Changing Dimensions in Power BI?<\/h2>\n<p>Power BI supports slowly changing dimensions through built-in tools.<\/p>\n<p>Use <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-vs-power-query\" target=\"_blank\" rel=\"noopener\">Power Query<\/a> to detect changes in data.<\/p>\n<p>Use <a href=\"https:\/\/chartexpo.com\/blog\/what-is-dax-in-power-bi\" target=\"_blank\" rel=\"noopener\">DAX<\/a> to build calculations that respond to time shifts.<\/p>\n<p>Use <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-data-flows\" target=\"_blank\" rel=\"noopener\">Dataflows<\/a> to automate the update process across tables.<\/p>\n<p>Want better visuals? Pair Power BI with ChartExpo. It works with no code. Connect your SCD table, choose a chart, and get a clean picture of the data.<\/p>\n<p>You can even <a href=\"https:\/\/chartexpo.com\/blog\/create-a-measure-in-power-bi\" target=\"_blank\" rel=\"noopener\">create a measure in Power BI<\/a> to flag active rows\u2014just filter where is_current = TRUE. That gives you clear, up-to-date reporting while keeping the full history available in the background.<\/p>\n<p><strong>Why use ChartExpo?<\/strong><\/p>\n<p>ChartExpo turns <a href=\"https:\/\/chartexpo.com\/blog\/data-visualization-guide\" target=\"_blank\" rel=\"noopener\">data visualization<\/a> into something anyone can use. No code. No headaches.<\/p>\n<p>It works as a <a href=\"https:\/\/chartexpo.com\/blog\/chart-maker\" target=\"_blank\" rel=\"noopener\">chart maker<\/a> that connects right into Power BI. Once your slowly changing dimensions are loaded, you choose from a set of charts designed for tracking change over time\u2014multi-axis lines, stacked bars, radar charts, <a href=\"https:\/\/chartexpo.com\/charts\/scatter-plot-chart\" target=\"_blank\" rel=\"noopener\">scatter charts<\/a>, and more.<\/p>\n<p>ChartExpo helps you tell the story of your data clearly. Trends, spikes, shifts\u2014all visible in seconds. It\u2019s fast, flexible, and built for teams who want real answers.<\/p>\n<p>And yes, you can try it free for 7 days.<\/p>\n<p><strong>Here\u2019s a Dataset <\/strong><\/p>\n<p>Before diving into visualization, let\u2019s break down the data. This table tracks monthly user trends across Customer Count, Active Users, and Churn Rate. Why does it matter? Each shift tells a story.<\/p>\n<p>April\u2019s spike suggests a major campaign or product change. June\u2019s dip might reflect disengagement. Tracking these metrics month-by-month gives a window into behavior and retention. Slowly changing dimensions don\u2019t just capture values\u2014they expose patterns over time.<\/p>\n<table class=\"static\" style=\"table-layout: fixed; border-collapse: collapse; width: 100%; font-size: 17px; border: 1px solid #ccc;\">\n<thead>\n<tr>\n<td style=\"text-align: center;\"><strong>Month<\/strong><\/td>\n<td style=\"text-align: center;\"><strong>Customer_Count<\/strong><\/td>\n<td style=\"text-align: center;\"><strong>Active_Users<\/strong><\/td>\n<td style=\"text-align: center;\"><strong>Churn_Rate (%)<\/strong><\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Jan<\/td>\n<td>1113<\/td>\n<td>1077<\/td>\n<td>5.03<\/td>\n<\/tr>\n<tr>\n<td>Feb<\/td>\n<td>978<\/td>\n<td>752<\/td>\n<td>6.27<\/td>\n<\/tr>\n<tr>\n<td>Mar<\/td>\n<td>956<\/td>\n<td>1046<\/td>\n<td>8.64<\/td>\n<\/tr>\n<tr>\n<td>Apr<\/td>\n<td>1139<\/td>\n<td>1079<\/td>\n<td>14.03<\/td>\n<\/tr>\n<tr>\n<td>May<\/td>\n<td>1020<\/td>\n<td>979<\/td>\n<td>13.25<\/td>\n<\/tr>\n<tr>\n<td>Jun<\/td>\n<td>1012<\/td>\n<td>744<\/td>\n<td>15.89<\/td>\n<\/tr>\n<tr>\n<td>Jul<\/td>\n<td>1007<\/td>\n<td>1002<\/td>\n<td>13.53<\/td>\n<\/tr>\n<tr>\n<td>Aug<\/td>\n<td>985<\/td>\n<td>916<\/td>\n<td>8.57<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Power BI Login:<\/strong><\/p>\n<ul>\n<li>Start by logging into Power BI.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-1.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-1.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Enter your password and sign in.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-2.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-2.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Choose whether you want to stay signed in.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-3.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-3.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Click \u201cPaste data into a blank report.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-4.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-4.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Name the table and hit \u201cLoad.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-5.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-5.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Click \u201cGet more visuals\u201d in the Visualizations panel.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-6.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-6.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Search for \u201cChartExpo\u201d and choose the Multi Axis Line Chart.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-7.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-7.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Click \u201cAdd.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-8.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-8.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Select the chart icon from the Visualizations panel.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-9.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-9.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Choose your category (Month) and measures (User stats).<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-10.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-10.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Enter your ChartExpo license key.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-11.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-11.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Now the watermark is gone.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-12.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-12.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Click \u201cEnter data.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-13.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-13.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Name and load the new table.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-14.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-14.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Check that a relationship is built between tables.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-15.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-15.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Select the Month column from the Sort Order table.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-16.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-16.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Choose \u201cSort by Order.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-17.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-17.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Use the Month from the Sort Order table in your chart.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-18.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-18.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>The chart now shows the correct order.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-19.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-19.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Change the title of the chart.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-20.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-20.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Sort the data columns as needed.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-21.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-21.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Adjust the data representation.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-22.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-22.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Tweak the axis layout.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-23.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-23.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Change the legend shape and color.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-24.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-24.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Modify bar width and opacity.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-25.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-25.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>Add a percentage sign to churn rate.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-26.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-26.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<ul>\n<li>This is how the chart looks now.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-27.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-27.jpg\" alt=\"Slowly Changing Dimensions\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQklNQUM4OTUrTXVsdGlBeGlzTGluZUNoYXJ0Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/> <\/a> <a href=\" https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTg5NSs=\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTg5NSs=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<h4>Key Insights<\/h4>\n<ul>\n<li><strong>April saw the highest churn rate at 14.03%.<\/strong> This signals potential dissatisfaction or seasonal drop-off, requiring follow-up.<\/li>\n<li><strong>June showed the steepest drop in active users.<\/strong> Engagement fell sharply, hinting at a possible usability issue or external factor.<\/li>\n<li><strong>Customer Count remains mostly stable.<\/strong> Despite dips, the overall customer count doesn\u2019t fluctuate heavily, showing solid retention.<\/li>\n<li><strong>July saw a recovery in active users.<\/strong> A strong comeback after June hints that corrective action worked or seasonality shifted.<\/li>\n<li><strong>May and August churn rates lowered.<\/strong> These months indicate better retention practices or improved user satisfaction.<\/li>\n<\/ul>\n<h2 id=\"techniques-for-maintaining-slowly-changing-dimensions\">Techniques for Maintaining Slowly Changing Dimensions<\/h2>\n<p>You need smart methods to manage change.<\/p>\n<ul>\n<li>Schedule refreshes for ETL pipelines. Regular updates reduce errors.<\/li>\n<li>Use hash functions to quickly check for changes across fields.<\/li>\n<li>Stick to surrogate keys for tracking records. Business keys can\u2019t handle versions cleanly.<\/li>\n<li>Add start_date and end_date for time filtering.<\/li>\n<li>Include a version number. It helps track the order of updates.<\/li>\n<\/ul>\n<p>These small changes make a big difference in clarity and consistency.<\/p>\n<h2 id=\"benefits-of-slowly-changing-dimensions-type-2\">Benefits of Slowly Changing Dimensions Type 2<\/h2>\n<p><strong>Slowly changing dimension type 2<\/strong> is popular for a reason.<\/p>\n<p>It records the full history without overwriting anything.<\/p>\n<p>It supports detailed <a href=\"https:\/\/chartexpo.com\/blog\/data-analytics-guide\" target=\"_blank\" rel=\"noopener\">data analytics<\/a>, tracking trends, user journeys, and behavior shifts.<\/p>\n<p>It works well with <a href=\"https:\/\/chartexpo.com\/blog\/visual-analytics\" target=\"_blank\" rel=\"noopener\">visual analytics<\/a>, especially in tools like Power BI.<\/p>\n<p>You get better filters. Use is_current or date ranges to split past and present.<\/p>\n<p>It scales for large datasets, making it ideal for enterprise use.<\/p>\n<h2 id=\"tips-for-using-slowly-changing-dimensions\">Tips for Using Slowly Changing Dimensions<\/h2>\n<p>Apply SCD Type 2 only where history matters. Not every field needs it.<\/p>\n<p>Use <a href=\"https:\/\/chartexpo.com\/blog\/dimensionality-reduction\" target=\"_blank\" rel=\"noopener\">dimensionality reduction<\/a> if your table gets too wide.<\/p>\n<p>Combine with ChartExpo to get clear visual comparisons.<\/p>\n<p>Validate your pipelines often. Could you not assume they\u2019re still accurate?<\/p>\n<p>Track across environments using the <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-deployment-pipelines\" target=\"_blank\" rel=\"noopener\">Power BI deployment pipeline<\/a>.<\/p>\n<h2 id=\"limitations-of-slowly-changing-dimensions\">Limitations of Slowly Changing Dimensions<\/h2>\n<p>No method is perfect.<\/p>\n<p>Slowly changing dimensions increase storage, especially Type 2.<\/p>\n<p>ETL logic gets more detailed. That takes time and planning.<\/p>\n<p>Large SCD tables may slow down performance, especially in visuals.<\/p>\n<p>It can be hard to see change without a tool like ChartExpo.<\/p>\n<p>Type 3 only keeps one previous value, limiting insight.<\/p>\n<p>Sometimes the trade-off is worth it. Sometimes it\u2019s not.<\/p>\n<p><a href=\"https:\/\/chartexpo.com\/blog\/power-bi-dashboard-vs-report\" target=\"_blank\" rel=\"noopener\">Power BI dashboard vs report<\/a> differences also affect how the data loads and performs.<\/p>\n<h2 id=\"faqs\">FAQs<\/h2>\n<h3>What Is SCD Type 1, 2, And 3?<\/h3>\n<p>Type 1 overwrites old values. Type 2 adds new rows for each change. Type 3 uses new columns to store past values.<\/p>\n<h3>What Is The Difference Between Type 1 And Type 2 Slowly Changing Dimensions?<\/h3>\n<p>Type 1 forgets the past. Type 2 keeps every version, giving you a full timeline for analysis.<\/p>\n<h4 id=\"wrap-up\">Wrap-up<\/h4>\n<p>Slowly changing dimensions don\u2019t just store values. They store time, truth, and transformation. Every record holds a story\u2014when it changed, how often, and what came before.<\/p>\n<p>This guide showed you how to set that up. From SCD types to Power BI visuals, you now know how to track change with purpose. The data isn\u2019t flat anymore\u2014it\u2019s alive.<\/p>\n<p>Use it. Build trust in your reports. Let your numbers speak clearly. And above all, never let valuable history go unrecorded.<\/p>\n<p>The future makes more sense when the past is remembered. That\u2019s the power of slowly changing dimensions.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Slowly changing dimensions track changes in business data over time, helping improve historical reporting accuracy and long-term analysis.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/chartexpo.com\/blog\/slowly-changing-dimensions\"><\/a><\/p>","protected":false},"author":1,"featured_media":53434,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[906],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Slowly Changing Dimensions: Insight and Visual Made Easy -<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/chartexpo.com\/blog\/slowly-changing-dimensions\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:title\" content=\"Slowly Changing Dimensions: Insight and Visual Made Easy -\" \/>\r\n<meta name=\"twitter:description\" content=\"Slowly changing dimensions track changes in business data over time, helping improve historical reporting accuracy and long-term analysis.\" \/>\r\n<meta name=\"twitter:image\" content=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-feature.jpg\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 minutes\" \/>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Slowly Changing Dimensions: Insight and Visual Made Easy -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/chartexpo.com\/blog\/slowly-changing-dimensions","twitter_card":"summary_large_image","twitter_title":"Slowly Changing Dimensions: Insight and Visual Made Easy -","twitter_description":"Slowly changing dimensions track changes in business data over time, helping improve historical reporting accuracy and long-term analysis.","twitter_image":"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/09\/slowly-changing-dimensions-feature.jpg","twitter_misc":{"Written by":"admin","Est. reading time":"16 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/chartexpo.com\/blog\/slowly-changing-dimensions","url":"https:\/\/chartexpo.com\/blog\/slowly-changing-dimensions","name":"Slowly Changing Dimensions: Insight and Visual Made Easy -","isPartOf":{"@id":"http:\/\/localhost\/blog\/#website"},"datePublished":"2025-09-12T04:48:16+00:00","dateModified":"2025-11-18T05:51:32+00:00","author":{"@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280"},"breadcrumb":{"@id":"https:\/\/chartexpo.com\/blog\/slowly-changing-dimensions#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartexpo.com\/blog\/slowly-changing-dimensions"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/chartexpo.com\/blog\/slowly-changing-dimensions#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/localhost\/blog"},{"@type":"ListItem","position":2,"name":"Slowly Changing Dimensions: Insight and Visual Made Easy"}]},{"@type":"WebSite","@id":"http:\/\/localhost\/blog\/#website","url":"http:\/\/localhost\/blog\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/localhost\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280","name":"admin","url":"https:\/\/chartexpo.com\/blog\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/53384"}],"collection":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/comments?post=53384"}],"version-history":[{"count":8,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/53384\/revisions"}],"predecessor-version":[{"id":55870,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/53384\/revisions\/55870"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media\/53434"}],"wp:attachment":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=53384"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=53384"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=53384"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}