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.
Hi, I'm trying to combine the description in the satisfaction column with the results in the PCT,
I used this code to get the PCT that you see here in the screen , and then used the format options in the menu to show it as a %
PCTOfGrandTotal =
DIVIDE(
[SatisfactionCount],
CALCULATE(SUM('_DFE - Satisfaction (2)'[SatisfactionCount]), ALL('_DFE - Satisfaction (2)'))
)
For example my goal would be something like
Very Satisfied - 80.86%
But when I use the FORMAT function, like this command
Any help is appreciated.
Solved! Go to Solution.
Hello,
Please try the following measure
Satisfaction %=
Selectedvalue([Satisfaction])&" - "&Round(PCTOfGrandTotal*100,2)&"%"
Thanks, For a measure that works perfectly!
But my needs are to use that text as part of a chart, and unfortunately I can't add measures to a chart.
Is there anyway around that? I'm using the final result you provided as a replacent for just the descriptions.
Something like this but with the formatted descriptions including the %
Hello,
Please try the following measure
Satisfaction %=
Selectedvalue([Satisfaction])&" - "&Round(PCTOfGrandTotal*100,2)&"%"
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
66 | |
34 | |
26 | |
22 |
User | Count |
---|---|
97 | |
96 | |
58 | |
45 | |
42 |