Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
See screenshot below. I created a new measure called NP% = (count('Scheduled and Arrived Appts'[New Patient Appts]) / count('Scheduled and Arrived Appts'[Appt Scheduled])) * 100. When that measure is put into a Line and Stacked Column chart, the data label shows too many decimal points. How can I get the data label to show only 2 decimal points?
Thanks in advance!
Solved! Go to Solution.
Instead of multiplying by 100, go to the data view, select your measure, then select the Modeling tab, then in the Formatting section, select the % icon, then select the # of digits,
Screenshot went missing from my last post
Instead of multiplying by 100, go to the data view, select your measure, then select the Modeling tab, then in the Formatting section, select the % icon, then select the # of digits,
Thanks for this note -- Yep, in my case, the Format options were not available from Report View.
From Data View however, you just select the measure from the Fields Pane and -- viola -- the Format options are active 🙂
I think when you use visual e.g stack bar chart and choose format -> data label -> on
The % will show as well as actual figure.
Hope this works for you.
Is there any way to add a % sign to the data label?
Can I add % to the data label in Power BI?
If you change the formatting as I specified above, the % sign will show up
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
80 | |
65 | |
52 | |
50 |
User | Count |
---|---|
211 | |
87 | |
80 | |
69 | |
60 |