Forum Discussion

tenfingers's avatar
tenfingers
Advocate II
6 years ago

Creating a calculation group in Tabular Editor disables the format dropdown in Measure Tools

When I create a simple calculation group in Tabular Editor, it greys out / disables the format dropdown in the formatting area of Measure Tools in Report and table view. I am still able to change for...
General Comment
sscott0203's avatar
sscott0203
Frequent Visitor
6 years ago

I'm also having the same problem

  • tenfingers's avatar
    tenfingers
    Advocate II
    6 years ago

    I have found some further details around this. 

    It seems to be triggered by using a custom format string for a calculation item in Tabular Editor. It also creates a hidden folder containing every measure in the table (seperate folders for each table). The measures in the hidden folder contain the format string of that measure:

    This doesnt seem like the correct behaviour to me.

     

    Cheers



    • tenfingers's avatar
      tenfingers
      Advocate II
      6 years ago

      It would also appear that I can no longer change the format string in Power BI at all. The option is available in the modelling tab but changing it appears to have no effect. The only way I can change the format of a measure is by using a custom format string in tabular editor.

      • tenfingers's avatar
        tenfingers
        Advocate II
        6 years ago

        Heard this exact thing mentioned on Guy in a Cube. Apparently it's a known issue and a fix is being worked on. Hopefully it's in the next release, it's making things painful for me creating and searching for measures. ✌️