Forum Discussion
Creating a calculation group in Tabular Editor disables the format dropdown in Measure Tools
I have also found that removing all custom format strings from calculation groups does not fix anything so once you go there, theres no going back. The only way I have found to fix the issue is to delete all calculation groups and start over. ✌
I've also been struggling with this since the External Tool integration was announced.
Here's how I can reproduce the issue:
1) Create a new PBI file in Desktop
2) Import data
3) Create a calculation group and 2 calculation items via Tabular Editor
4) Save the changes, and now measure formatting in Power BI Desktop is broken.
Here's a gif of what happens to the formatting features after these steps. Note that the format string changes when I use the format buttons, but I cannot set the format string directly nor can I choose "Whole Number" from the usual drop down. Also note that the visual does not refresh and update when I change the formatting; it only refreshes when I change the measure name.
tenfingers, I can "fix" my PBIX by deleting the Calculation Group and then disabling Discourage Implicit Measures on the Model node in Tabular Editor.
If I only create 1 Calcuation Item that returns SelectedMeasure() then this problem doesn't seem to happen. When I add a second Item that returns AverageX, then it does. Deleting the 2nd item does not make this problem go away. I tried having every Item in the Calc Group return the same data type, whether double or String, the problem still happens.
I am not using Format String Expression on any Calculation Items.