Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 |
---|---|
82 | |
79 | |
65 | |
48 | |
45 |
User | Count |
---|---|
103 | |
44 | |
39 | |
39 | |
39 |