<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic valueFormatter numeric on table visual in Custom Visuals Development Discussion</title>
    <link>https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/valueFormatter-numeric-on-table-visual/m-p/3853984#M9486</link>
    <description>&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am implementing the valueFormatter on a custom visual that hosts data in a table. I have followed the documentation in &lt;A href="https://learn.microsoft.com/en-us/power-bi/developer/visuals/dynamic-format" target="_self"&gt;this link&lt;/A&gt;, but it seems this only covers categorical. Formats on numeric measures in table view seem to attach themselves directly to the row values rather than being located elsewhere.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The example below shows a row array found within the dataview.table.rows. In this example, the fourth element of the array is a numeric measure, and the fifth element is its format string. This format string is found in every single record of the array.&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;[
    "s471",
    "\"Bridgerton\" cast members share behind-the-scenes stories from the hit show, plus comedian Nikki Glaser breaks down the costume drama's sexiest moments.",
    "2021-07-12T22:00:00.000Z",
    0.34014698024839163,
    "#.########EUR",
    "39 min"
]&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Likewise, adding a dynamic formatting string to a measure also seems to add a column in dataviews.table.columns. This column always looks like this:&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;{
    "displayName": "",
    "isMeasure": true
}&lt;/LI-CODE&gt;&lt;P&gt;And its placement in the array is also after the numeric measure (with a format), so I assume it's related to this.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Before implementing the valueformatter, linking rows and columns was extremely easy and intuitive. This is obviously not a major hurdle, but can it really be that a whole column is added to the metadata and every record has the format string? This is&amp;nbsp;not the case when I add formatting to a date, as the formatting string is found directly within the metadata column.&lt;/P&gt;</description>
    <pubDate>Fri, 19 Apr 2024 14:00:54 GMT</pubDate>
    <dc:creator>JSJB</dc:creator>
    <dc:date>2024-04-19T14:00:54Z</dc:date>
    <item>
      <title>valueFormatter numeric on table visual</title>
      <link>https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/valueFormatter-numeric-on-table-visual/m-p/3853984#M9486</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am implementing the valueFormatter on a custom visual that hosts data in a table. I have followed the documentation in &lt;A href="https://learn.microsoft.com/en-us/power-bi/developer/visuals/dynamic-format" target="_self"&gt;this link&lt;/A&gt;, but it seems this only covers categorical. Formats on numeric measures in table view seem to attach themselves directly to the row values rather than being located elsewhere.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The example below shows a row array found within the dataview.table.rows. In this example, the fourth element of the array is a numeric measure, and the fifth element is its format string. This format string is found in every single record of the array.&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;[
    "s471",
    "\"Bridgerton\" cast members share behind-the-scenes stories from the hit show, plus comedian Nikki Glaser breaks down the costume drama's sexiest moments.",
    "2021-07-12T22:00:00.000Z",
    0.34014698024839163,
    "#.########EUR",
    "39 min"
]&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Likewise, adding a dynamic formatting string to a measure also seems to add a column in dataviews.table.columns. This column always looks like this:&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;{
    "displayName": "",
    "isMeasure": true
}&lt;/LI-CODE&gt;&lt;P&gt;And its placement in the array is also after the numeric measure (with a format), so I assume it's related to this.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Before implementing the valueformatter, linking rows and columns was extremely easy and intuitive. This is obviously not a major hurdle, but can it really be that a whole column is added to the metadata and every record has the format string? This is&amp;nbsp;not the case when I add formatting to a date, as the formatting string is found directly within the metadata column.&lt;/P&gt;</description>
      <pubDate>Fri, 19 Apr 2024 14:00:54 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/valueFormatter-numeric-on-table-visual/m-p/3853984#M9486</guid>
      <dc:creator>JSJB</dc:creator>
      <dc:date>2024-04-19T14:00:54Z</dc:date>
    </item>
  </channel>
</rss>

