Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I'm currently using a parameter to switch the metric being displayed on a time series chart. However, one format is in dollars, while the other is in percent. The client really wants the percentages to be displayed in the XX.X% formatt. Is there any way I can achieve this within DAX code for the measure? Or in any other way really.
Here is the code for the measure.
Metric =
IF('Parameter'[Parameter Value]="Dollars",
SUM('Table'[Dollars]),
SUM('Table'[Percent]))
Please note that I am already using Field Parameters for this Metric, as there are three categories for the metric and the user needs to be able to choose which metrics they want displayed.
Metric =
IF (
'Parameter'[Parameter Value] = "Dollars",
SUM ( 'Table'[Dollars] ),
FORMAT ( SUM ( 'Table'[Percent] ), "Percent" )
)
Hello @Anonymous ,
try this one....
thank you!
Mahesh Patel
Hi @Mahesh0016 , this doesn't seem to work. I only get a total percentage for all data points, it doesn't work on the line chart anymore.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 104 | |
| 81 | |
| 66 | |
| 50 | |
| 45 |