{"id":83876,"date":"2019-04-15T18:31:40","date_gmt":"2019-04-15T18:31:40","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=83876"},"modified":"2022-04-24T21:07:02","modified_gmt":"2022-04-24T21:07:02","slug":"power-bi-and-the-matrix-a-challenge","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/databases\/sql-server\/bi-sql-server\/power-bi-and-the-matrix-a-challenge\/","title":{"rendered":"Power BI and The Matrix: A Challenge"},"content":{"rendered":"

In this article, I will show an example to demonstrate some interesting techniques using the Matrix visual. This was inspired by a friend, Albert Herd<\/a>, who asked for some help in our Malta user group to solve a problem.<\/p>\n

The data used in the example is the list of numbers drawn on the Maltese lotto. Each record is one number from a drawing, and each drawing has five records which are the five numbers from each drawing. You can download a zip file<\/a> containing a csv<\/em> file with the source data, a pbix<\/em> file with the data already imported to start creating the visuals, and the completed solution.<\/p>\n

By using the Matrix visualization, the numbers for each drawing can be displayed as a single line as shown in this figure.<\/p>\n

<\/p>\n

The goal is to add a slicer that filters the rows based on the number or numbers chosen. For example, if you select 5 and 10, the rows that contain those numbers will be displayed:<\/p>\n

<\/p>\n

It\u2019s also possible to add conditional formatting so that the selected numbers light up in the colour of your choice.<\/p>\n

<\/p>\n

Accomplishing this is not as straightforward as it might seem. Continue reading to learn more.<\/p>\n

The Data<\/h2>\n

Each record in the table is one number drawn on a specific lotto drawing. Each drawing has 5 numbers, so each drawing has 5 records in the table. The table is called Lotto,<\/em> and the fields most important for this example are these:<\/p>\n

DrawNo:<\/strong> The number of the drawing<\/p>\n

DrawOrder:<\/strong> The order of the drawn number<\/p>\n

Number:<\/strong> The drawn number<\/p>\n

Starting with a new Power BI dashboard and import the csv file. As an alternative, you can also start with the MatrixSimpleStart.pbix<\/em> file provided in the zip file.<\/p>\n

Creating the Matrix<\/h2>\n

The Matrix visual has three fields to be configured: the field used for the rows, the field used for the columns, and the field used for the values. Each line of the visual should show a single drawing with the five numbers. Due to that, the field for the rows will be the DrawNo<\/em>, aggregating the drawings on each row.<\/p>\n

Each drawing has five records, the five drawn numbers, so how do you show five records on each line? The content of the field you choose as a column<\/em> field will be used as the title of the columns. The best choice is easy: DrawOrder<\/em>. Each row shows the DrawNo<\/em>. Each column has the DrawOrder<\/em> as a title and will show the drawn Number<\/em> as a value in the column.<\/p>\n

Once you have the file MatrixSampleStart.pbix <\/em>opened or the csv file imported, follow a simple sequence of steps to configure the Matrix visual. You\u2019ll be working in Report<\/em> view.<\/p>\n

    \n
  1. \n
      \n
    1. <\/a> Add a Matrix<\/em> visual to the report from the Visualizations<\/em> pane<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

      <\/p>\n

        \n
      1. \n
          \n
        1. In the Fields Pane<\/em>, drag the three fields, DrawNo<\/em>, DrawOrder,<\/em> and Number <\/em>to the correct slots.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

          <\/p>\n

          Once you have the fields in the correct spots, the Matrix will resemble this image:<\/p>\n

          <\/p>\n

            \n
          1. \n
              \n
            1. In the Visualizations<\/em> Pane<\/em>, with the matrix selected, click the Format<\/em> button and disable the subtotals for rows and columns as they are not needed.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

              <\/p>\n

              <\/p>\n

                \n
              1. \n
                  \n
                1. While still in the Format<\/em> tab, under the Style<\/em> option, change the style of the matrix. You can choose any available style; I suggest Bold Header.<\/em><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

                  <\/p>\n

                    \n
                  1. Still in the Format<\/em> tab, change the font size under these three different options: Row<\/em> Headers<\/em>, Column<\/em> Headers,<\/em> and Values<\/em>. <\/strong>I like to use 12 as font size.<\/li>\n<\/ol>\n

                    <\/p>\n

                    The completed Matrix should look like this:<\/p>\n

                    <\/p>\n

                    Creating a Slicer and Filtering the Matrix<\/h2>\n

                    The matrix contains numbers from lotto drawings, so a good option for a slicer is to filter the drawn numbers, showing only the drawings with the selected drawn numbers.<\/p>\n

                    There are three possible approaches to create a slicer:<\/p>\n

                      \n
                    • Create a slicer based on the original table fields (Lotto<\/em>)<\/li>\n
                    • Create a slicer based on a new calculated table by using a DAX<\/strong> expression to create the new table from the original one<\/li>\n
                    • Create a slicer based on a What-If<\/strong> parameter<\/li>\n<\/ul>\n

                      NOTE: DAX<\/strong> is an expression language used in tabular models, such as the model in Power BI<\/strong>, to allow creating calculations over the model.<\/p>\n

                      The first two options keep a relationship with the original table (Lotto<\/em>). Although this relationship is not important for the result at all, it causes a small bug. The slicer needs to be inserted in the page before the matrix. If the slicer is inserted after the matrix, some of the slicer configurations will not be available. The slicer needs to be inserted first.<\/p>\n

                      Creating a Slicer from the Same Table<\/h2>\n

                      The easiest way to add a slicer is from a field in the table. Unfortunately, it doesn\u2019t quite provide the solution in this case. Follow these steps to see how to add a slicer based on the table:<\/p>\n

                        \n
                      1. \n
                          \n
                        1. Drop the matrix<\/li>\n
                        2. In the Fields<\/em> Pane<\/em>, select the Number<\/em> field in the Lotto table<\/li>\n
                        3. In the Visualizations<\/em> Pane<\/em>, change the visual to Slicer<\/em><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

                          <\/p>\n

                            \n
                          1. \n
                              \n
                            1. In the slicer type option, inside the slicer, change the slicer format to List<\/em><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

                              <\/p>\n

                                \n
                              1. \n
                                  \n
                                1. In the Visualizations Pane<\/em>, with the slicer selected, click the Format<\/em> button. In the Selection<\/em> Control<\/em> options, disable the Single<\/em> Select<\/em> option, allowing multiple numbers selection<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

                                  <\/p>\n

                                    \n
                                  1. Repeat the steps in the \u201cCreate the Matrix\u201d section to recreate the matrix.<\/li>\n<\/ol>\n

                                    To test this solution, select two numbers, such as 5 and 10, in the slicer and look at the result in the matrix. You will notice two problems:<\/p>\n

                                      \n
                                    • The draws are filtered to show only the selected numbers instead of all the numbers of the selected draws. That’s not the best result for this solution.<\/li>\n
                                    • The multiple selections act as an OR<\/strong>, not an AND<\/strong>. Draws with only one of the two selected numbers appear.<\/li>\n<\/ul>\n

                                      <\/p>\n

                                      Fixing the Selection<\/strong><\/p>\n

                                      In order to fix the selection, a different approach for this problem is needed. The filter is automatically made by the model and visual engine in Power BI, showing only the selected numbers. In order to show all the numbers of the selected draws, you will need to break the automatic filter and create a DAX<\/strong> formula that will control which draws need to appear.<\/p>\n

                                      This leads back to the decision about how to build the slicer: Building the slicer directly from the draws table (Lotto<\/em>) creates a relationship that can’t be broken. That’s the only slicer option that will not work. If you choose to build the slicer from a calculated table or What-If<\/em> parameter, the relationship to the source table (Lotto<\/em>) can be controlled, avoiding the filtering.<\/p>\n

                                      Once the matrix is not directly filtered by the slicer, you can create a DAX<\/strong> formula to filter the drawings. The expression will need to compare the numbers on the current drawing row to the selected numbers on the slicer, identifying if the row should be displayed or not.<\/p>\n

                                      First, you\u2019ll see the two additional ways to create the slicer, both using a helper table. You can choose either method.<\/p>\n

                                      Creating the Slicer – Calculated Table<\/h2>\n

                                      You can create this table using a very simple DAX expression. On the top menu, Modeling<\/em> tab, you\u2019ll find a button called New<\/em> Table<\/em>. After clicking this button, a space expands where you can introduce the DAX<\/strong> expression for this table.<\/p>\n

                                      <\/p>\n

                                      Call the table Selector<\/em>. The expression is very simple:<\/p>\n

                                      Selector\u00a0= VALUES\u00a0(Lotto[Number]\u00a0)<\/pre>\n
                                      <\/p>\n
                                      The newly created table, Selector<\/em>, will have no relationship with the original one. Although it was created from the Lotto<\/em> rows, the only effect will be the strange visual behaviour that requires the slicer to be created before the matrix.<\/p>\n
                                      <\/p>\n
                                      Choosing this option for the Selector<\/em> table, you will need to execute the following steps:<\/p>\n
                                        \n
                                      1. Drop the slicer<\/li>\n
                                      2. Drop the matrix<\/li>\n
                                      3. Create the slicer again using the steps from the \u201cCreating a Slicer from the Same Table\u201d section but use the Number<\/em> field from the Selector<\/em> table<\/li>\n
                                      4. Create the matrix again<\/li>\n<\/ol>\n
                                        Note that at this point, the slicer will not filter the data. Continue reading to learn how to get it to work filtering the matrix.<\/p>\n
                                        Creating the Slicer from the What-if Parameter<\/h2>\n
                                        Instead of creating the Selector<\/em> table based on the Lotto<\/em> table, you can create a What-if<\/em> parameter. This is a new table with no relationship to the Lotto<\/em> table.<\/p>\n
                                        If you created the Selector based on the table in the previous section, delete it before following these steps.<\/p>\n
                                          \n
                                        1. \n
                                            \n
                                          1. Delete the matrix<\/li>\n
                                          2. On the top menu, Modeling<\/em> tab, click the Create<\/em> Parameter<\/em> button to bring up the What-if Parameter<\/em> window.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
                                            <\/p>\n
                                              \n
                                            1. Change the Name<\/em> to Selector<\/em> and specify a table of values from 1 to 99.<\/li>\n
                                            2. Click OK<\/em> once the properties have been filled in<\/li>\n<\/ol>\n
                                              <\/p>\n
                                              \nThe DAX formula generated behind the scenes is:<\/p>\n
                                              Selector\u00a0= GENERATESERIES\u00a0(\u00a01,\u00a099,\u00a01\u00a0)<\/pre>\n
                                              You\u2019ll see the new measure in the Fields<\/em> pane:<\/p>\n
                                               <\/p>\n
                                              As you will notice on the image above, there is one small difference on this option: the field created inside the Selector<\/em> table is also called Selector<\/em> instead of Number<\/em> as on the previous option.<\/p>\n
                                              In order to make both options the same, you can rename the Selector<\/em> field to Number<\/em>. It\u2019s optional, but if you don\u2019t, the following expressions will need to use Selector[Selector]<\/code> to refer to this field instead of Selector[Number].<\/code> <\/p>\n
                                              The steps to rename this field:<\/p>\n
                                                \n
                                              1. In the Fields<\/em> pane, under the Selector<\/em> table, next to the Selector<\/em> field, click the \u2018\u2026\u2019 (More Options<\/em>) button<\/li>\n
                                              2. Click the Rename<\/em> menu item in the context menu that will appear<\/li>\n
                                              3. Change the field name to Number<\/em><\/li>\n<\/ol>\n
                                                Follow these steps to complete the slicer<\/p>\n
                                                  \n
                                                1. Repeat the formatting (steps 4 and 5 in the \u201cCreating a Slicer from the Same Table\u201d) to format the new slicer that will be automatically added to the report.<\/li>\n
                                                2. Recreate the matrix as shown in the \u201cCreating the Matrix\u201d section<\/li>\n<\/ol>\n
                                                  If you chose this method for the slicer, continue to learn how to get it to work filtering the matrix.<\/p>\n
                                                  Measures vs. Calculated Columns<\/h2>\n
                                                  Before going forward, it\u2019s interesting to understand why to create measures and not calculated columns. Both measures and calculated columns accept DAX<\/strong> expressions. However, they have some differences. While the calculated column expression is evaluated in the row context, row by row, measures are used on aggregations.<\/p>\n
                                                  Another significant difference, usually the easiest one to help with the decision, is when the calculation is made. The calculated column expressions are evaluated when the table is processed, and the result is stored within the Power BI<\/strong> file. This means they can\u2019t rely on any interaction with the visuals, because they are calculated before.<\/p>\n
                                                  This makes the decision easy: you need measures that will react to the selection on the slicer as the user make it. The fact these measures will be calculated on each line of the matrix, which in fact is an aggregation of five records, is just an additional reason.<\/p>\n
                                                  Creating the Measures for Filtering<\/h2>\n
                                                  To filter the rows according to the selected numbers, you will need to create one measure to identify if each row has the selected numbers on the slicer. It’s a boolean<\/code> measure which should result in true<\/code> or false<\/code>, but here comes the first trick: Power BI doesn’t deal very well with boolean<\/code> measures used for filtering, so you need to create it as a numeric measure resulting in 1 or 0.<\/p>\n
                                                  Another concern about this formula is to display all the rows when there is no selection in the slicer. In this case, the measure should return 1 for all the rows, showing everything.<\/p>\n
                                                  This measure will be calculated for each row of the matrix, and each row of the matrix has a set of five numbers. The slicer, on the other hand, also will have a set of numbers selected and you don\u2019t know how many. If the drawing numbers in the row contain all the numbers of the slicer, the result should be 1 (show the line), otherwise 0.<\/p>\n
                                                  A DAX<\/strong> expression allows you to create variables inside the expression, and you can put this to good use to solve this problem. Here is the beginning of the expression:<\/p>\n
                                                  LineFilter\u00a0=\r\nVAR\u00a0tab\u00a0=\u00a0\u00a0\u00a0VALUES\u00a0(Selector[Number]\u00a0)\r\nVAR\u00a0tab2\u00a0=\u00a0\u00a0VALUES\u00a0(\u00a0Lotto[Number]\u00a0)\r\nVAR\u00a0common\u00a0=\u00a0\u00a0INTERSECT\u00a0(\u00a0tab,\u00a0tab2\u00a0)\r\nVAR\u00a0rowsCommon\u00a0=\u00a0\u00a0COUNTROWS\u00a0(\u00a0common\u00a0)\r\nVAR\u00a0rowsSelected\u00a0=\u00a0\u00a0COUNTROWS\u00a0(\u00a0tab\u00a0)<\/pre>\n
                                                  \nIt’s essential to consider the context used to process this expression. The Values<\/code> function over the Selector<\/code> table will return only the numbers selected on the slicer or all the numbers, while the Values<\/code> function over the Lotto<\/code> table will return only the numbers for the current drawing line, since the expression will be analysed for each line of the matrix.<\/p>\n
                                                  On the final part of the expression, if the rowsCommon<\/code> variable is equal to the rowsSelected<\/code> variable, it means all numbers selected on the slicer are on this drawing, and the result will be 1. Otherwise, it will be 0. However, you need also to consider if the slicer is not filtered at all. For this, you have the ISFILTERED<\/code> DAX<\/strong> function.<\/p>\n
                                                  The full DAX<\/strong> expression is:<\/p>\n
                                                  LineFilter\u00a0=\r\nVAR\u00a0tab\u00a0=\u00a0\u00a0\u00a0VALUES\u00a0(\u00a0Selector[Number]\u00a0)\r\nVAR\u00a0tab2\u00a0=\u00a0\u00a0VALUES\u00a0(\u00a0Lotto[Number]\u00a0)\r\nVAR\u00a0common\u00a0=\u00a0\u00a0INTERSECT\u00a0(\u00a0tab,\u00a0tab2\u00a0)\r\nVAR\u00a0rowsCommon\u00a0=\u00a0\u00a0COUNTROWS\u00a0(\u00a0common\u00a0)\r\nVAR\u00a0rowsSelected\u00a0=\u00a0\u00a0COUNTROWS\u00a0(\u00a0tab\u00a0)\r\nRETURN\r\n\u00a0\u00a0\u00a0\u00a0IF\u00a0(\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0OR\u00a0(\u00a0rowsCommon\u00a0=\u00a0rowsSelected,\u00a0\r\n          NOT\u00a0(\u00a0ISFILTERED\u00a0(\u00a0Selector[Number]\u00a0)\u00a0)\u00a0);\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a01,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\r\n\u00a0\u00a0\u00a0\u00a0)<\/pre>\n
                                                  The steps to use this expression are the following:<\/p>\n
                                                    \n
                                                  1. \n
                                                      \n
                                                    1. In the Fields<\/em> pane, Click the ‘…’ (More Options)<\/em> button close to the Lotto<\/em> table<\/li>\n
                                                    2. Click the New Measure<\/em> menu option in the context menu that will appear<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
                                                      <\/p>\n
                                                        \n
                                                      1. \n
                                                          \n
                                                        1. Paste the entire expression, including the measure name, in the formula bar<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
                                                          <\/p>\n
                                                            \n
                                                          1. \n
                                                              \n
                                                            1. Drag the newly created measure to the filter area of the matrix configuration<\/li>\n
                                                            2. Change the comparison expression Show items when the value<\/em> to is<\/em><\/li>\n
                                                            3. Fill the value expression with 1<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
                                                              <\/p>\n
                                                                \n
                                                              1. Click Apply<\/code> Filter<\/code><\/li>\n<\/ol>\n
                                                                After completing these steps, the filter will be working. When you select multiple numbers on the slicer, you will see only the draws that contain all the selected numbers.<\/p>\n
                                                                <\/p>\n
                                                                Conditional Formatting<\/h2>\n
                                                                The conditional format is the \u201ccherry on top\u201d of this solution. You can not only filter the drawings, but you can also highlight the numbers selected on the slicer within each line with a different colour.<\/p>\n
                                                                The numbers selected in the slicer should appear in red or whatever colour you select. This is too complex for the conditional formatting. Due to that, you need a new measure that tells you, for each number in the drawing, if it’s selected or not.<\/p>\n
                                                                Since this measure will be used only for conditional filtering, it will be processed for each number and not sets of numbers. However, since it’s a measure, you still need to apply an aggregation function to the Number<\/em> field, a simple SUM<\/code> will do the job.<\/p>\n
                                                                The final measure will look like this:<\/p>\n
                                                                NumFilter\u00a0=\r\nVAR\u00a0tab\u00a0= VALUES\u00a0(Selector[Number]\u00a0)\r\nRETURN\r\n\u00a0\u00a0\u00a0\u00a0IF\u00a0(\u00a0SUM\u00a0(\u00a0Lotto[Number]\u00a0)\u00a0IN\u00a0tab,\u00a01,\u00a00\u00a0)<\/pre>\n
                                                                The steps to complete the conditional formatting are:<\/p>\n
                                                                  \n
                                                                1. \n
                                                                    \n
                                                                  1. In the Fields<\/em> pane, Click the ‘…’ (More Options)<\/em> button close to the Lotto<\/em> table<\/li>\n
                                                                  2. Click the New Measure<\/em> menu option in the context menu that will appear<\/li>\n
                                                                  3. Paste the entire expression, including the measure name, in the formula bar<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
                                                                    <\/p>\n
                                                                      \n
                                                                    1. \n
                                                                        \n
                                                                      1. Select the matrix visual on the main pane<\/li>\n
                                                                      2. In the Visualizations<\/em> pane, with the matrix selected, click the Format<\/em> button<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
                                                                        <\/p>\n
                                                                          \n
                                                                        1. \n
                                                                            \n
                                                                          1. In the Visualizations<\/em> pane, open Conditional<\/em> formatting<\/em><\/li>\n
                                                                          2. Under the Conditional<\/em> Formatting<\/em> element, enable Font<\/em> color<\/em> option<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
                                                                            <\/p>\n
                                                                              \n
                                                                            1. \n
                                                                                \n
                                                                              1. Click on the Advanced<\/em> Controls<\/em> link that will appear below the Font<\/em> color<\/em> option<\/li>\n
                                                                              2. In the Font<\/em> color<\/em> window, on the Format<\/em> by<\/em> dropdown box, select Rules<\/em><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
                                                                                <\/p>\n
                                                                                  \n
                                                                                1. \n
                                                                                    \n
                                                                                  1. On the Based on field<\/em> dropdown box, select the measure, NumFilter<\/em><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
                                                                                    <\/p>\n
                                                                                      \n
                                                                                    1. \n
                                                                                        \n
                                                                                      1. On the If value<\/em> dropdown box select the is<\/em> option<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
                                                                                        <\/p>\n
                                                                                          \n
                                                                                        1. Type 1 in the textbox besides the previous dropdown<\/li>\n
                                                                                        2. Select Red<\/em> in the color picker, if not selected already<\/li>\n
                                                                                        3. Click Ok<\/em><\/li>\n<\/ol>\n
                                                                                          Once you have followed the steps, you should see the selected numbers light up in red or the colour that you selected.<\/p>\n
                                                                                          <\/p>\n
                                                                                          Summary<\/h2>\n
                                                                                          Using some interesting DAX<\/strong> expressions, each line of a matrix could be filtered according to a slicer. In addition, the numbers selected could be highlighted. Of course, this is a very specific example, but I\u2019m sure you can adapt the expressions shown here to your challenges using the Matrix visual.<\/p>\n
                                                                                           <\/p>\n","protected":false},"excerpt":{"rendered":"
                                                                                          The Matrix is one of the many built-in visualizations found in Power BI. While the Matrix is easy to populate, filtering it is not so straightforward. In this article, Dennes Torres explains how to add a slicer that does the job.…<\/p>\n","protected":false},"author":50808,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[143528],"tags":[],"coauthors":[6810],"class_list":["post-83876","post","type-post","status-publish","format-standard","hentry","category-bi-sql-server"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/83876","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/50808"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=83876"}],"version-history":[{"count":9,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/83876\/revisions"}],"predecessor-version":[{"id":94016,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/83876\/revisions\/94016"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=83876"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=83876"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=83876"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=83876"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}