fredrikheden / summarytable

Summary Table Custom Visual for Power BI
33 stars 17 forks source link

Measure names with parentheses #16

Open tdfa opened 5 years ago

tdfa commented 5 years ago

Using this visual for a P&L statement, we have a measure named 'NET INCOME (LOSS)' which isn't pulling through. All of the other measures are pulling correctly and this follows the same syntax as the others but I'm guessing due to the parenthesis this is getting dropped. I've double checked the names match and swapping the measure used in the formula line pulls correctly after being switched to a measure that doesn't have parenthesis. Are parenthesis supported in measure names?

    {
        "title": "NET MARGIN",
        "formula": "[NET INCOME (LOSS)]",
        "rowStyle": "",
        "visible": true,
        "cellRowHeaderStyle": "font-weight: bold; padding-top: 2px; border-top-color: #E6E6E6; border-top-style: solid; border-top-width: 1px",
        "cellRowDataStyle": "padding-top: 2px; border-top-color: #E6E6E6; border-top-style: solid; border-top-width: 1px"
    },
fredrikheden commented 5 years ago

Thanks for reporting this. I can confirm that this is a bug (with no workaround). It has been fixed in v 1.4.4, which is not released yet. If you want a bug fix right away you can use the dev version of 1.4.4 that is published in the dev folder.

tdfa commented 5 years ago

1.4.4 looks to be working. Thanks!