Forum Discussion

Alex7's avatar
Alex7
Regular Visitor
3 years ago
Solved

Add a Nr column to matrix

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.

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

     

     

     

3 Replies