Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
In case it helps someone - I have done it with FORMAT function direct in SWITCH function.
In case it helps someone - I have done it with FORMAT function direct in SWITCH function.
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.
User | Count |
---|---|
76 | |
75 | |
46 | |
31 | |
27 |
User | Count |
---|---|
99 | |
91 | |
51 | |
48 | |
47 |