Column Groups, format strings and/or referencing columns

[TheWizardofData]

Hi!
I'm using Power BI Report Server with a SSAS tabular model as data source. In the model I have three Column Groups which I'm using to easily create PNL statements. Two of them are used for columns and one for rows. Everything works well using the built-in matrix in Power BI, although we all know the limitations of that one, so I'm looking into the possibility of using the Profitbase Matrix. The only issue I've run into is that I'm not able to change the format string of my columns. Rows are working just fine, but when I right-click a column and choose Add column formula I'm only getting a step with my measure within parenthesis. When typing formulas I'm able to click the values in the matrix to reference a column though, if that's meaningful information for anyone. Maybe the solution is to use something corresponding to RowHeader, but for columns, and style the rows instead?

In the attached image I've right-clicked [Budget Dev %] and chosen Add column formula, which has given me the bottom step Column Formula(Sum All Accounts). Sum All Accounts is my measure, and the only measure I'm using in the visual.

Am I missing something or are calculated column groups not fully supported? The second image shows how the standard matrix inherits the format string from SSAS and gets the percentage formatting correct in the [Budget Dev %] column without me doing anything in Power BI. That's of course the way I would want the Profitbase Matrix to work as well.
The third image shows that the visual seem to think that my rows and my measure are the columns. Hence I can't really style the column headers individually, which I assume is caused by the same issue.

[toresenneseth]

Hi, sorry for the late response.

We believe this is an issue related to calculated column groups, and we are investigating it now.
Also, picking up the formatting from the data model is in our backlog, but it is currently not supported.

[TheWizardofData]

Ok, great! Sounds likely that this has to do with column groups not being recognized as real columns.

Säg till om ni vill att jag skall bidra på något sätt!

[AndersAano]

Been a while since this was opened.

In v7, being released on GitHub now, we have added support for inheriting format strings.
So setting a % formatting for one of the fields coming from Tabular Editor will work as expected.

-Anders