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
TrevorC's avatar
TrevorC
Advocate I
5 years ago

Having the same issue. Not tied to custom formatting in Calcualtion Group.

 

I tracked it down to one calculation. An image of the calulation item is below. There is no way to work around this. All calculations in the image cause the issue. Note: 1+1 and 1-1 cause the issue as well.

 

 

I think that it is due to the number of calculation items. My CG currently has 6. When I add one more, even one with the value of 1, it causes the issue.

 

 

 

 

  • tenfingers's avatar
    tenfingers
    Advocate II
    5 years ago

    TrevorC 
    Thats interesting, I played around a bit but couldnt replicate the behaviour using different amounts of calculation items and SAMEPERIODLASTYEAR. I did find that entering any numerical value in a calculation item instantly breaks the measure formatting. I asked wether this issue would be fixed in a twitter thread and some members of the power BI team replied that it would be fixed for External Tools GA, although I cant find any reference anywhere as to when this is planned.

    • tenfingers's avatar
      tenfingers
      Advocate II
      5 years ago

      Actually I was able to break it using a version of your Measure 3.