Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I know powerbi treat everything in a column in a consistent format, like everything has to be either $ or time/date or whole number.
But for displaying purpose, I have a need to customize things at row-level like in Excel, ie. this row it's $ amount, next row it's Count, next row is % (users want to see the sign)
Any suggestion to achieve that? please
Solved! Go to Solution.
you can try something like this (look only the format)
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
you can try something like this (look only the format)
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
My bad, I format that column 4Q PR as text, because there are text in the first row of the column.
So I play with it as text : "$" & value or value &"%".
I try to use it but it doesnt work. I am using a table since Matrix is aggregating everything.
Look at the Test1 measure, even it's Currency or percent it doesnt work.
Here is the data
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
77 | |
60 | |
52 |
User | Count |
---|---|
165 | |
86 | |
68 | |
68 | |
58 |