Add a Nr column to matrix

[Alex7]

Hello dear PBI Community,

I have a quite simple quesion, but did not find any solution for me. I want just to add a serial nr column (this should be the first column in a matrix) to a matrix.

Some useful infos:

I use the option "Switch values to rows"

I have found a way to add a nr column with measure table and switch function (please see a pbix file). But in this case I cannot format each measure as I want - I have some measures formatted as $ and some as %.

Link to pbix file: https://www.dropbox.com/s/efqjlzwtl0fnka9/Column%20Nr.pbix?dl=0

So I need to either add a new nr column or find a way to format the measures differently ($ and %) in case using measure table and switch function. Please see the pbix file. First option is preferred.

If it is possible for you please propose your solution directly in the attached pbix file with a short description of what you did. Thank you!

Any help would be much appreciated.

[Alex7 · Accepted solution]

In case it helps someone - I have done it with FORMAT function direct in SWITCH function.

[lbendlin]

But in this case I cannot format each measure as I want - I have some measures formatted as $ and some as %.

Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn

[Alex7]

Hello Ibendlin, yes, thanks. I have done it with FORMAT function.