Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Alex7
Regular Visitor

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.

1 ACCEPTED SOLUTION
Alex7
Regular Visitor

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

 

Alex7_0-1693936386304.png

 

 

View solution in original post

3 REPLIES 3
Alex7
Regular Visitor

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

 

Alex7_0-1693936386304.png

 

 

lbendlin
Super User
Super User

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

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

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors