You can achieve what you’re describing by using dynamic format strings for measures in Power BI. The approach is to let the format adjust automatically based on the data type in your model, so when the value represents a percentage, it displays with a % sign, and when it’s a plain number, it appears without it. To do this, first create a measure for your KPI value and then open the Measure tools pane to set up a dynamic format string using an expression. For example, you can use a DAX expression that checks the data type and switches the format accordingly, something like: if the data type is Percentage, return 0.0%; if it’s Number, return 0.0; otherwise, use a general format. Once you apply this, the same measure will automatically show the correct format for each KPI in your line chart without the need for multiple visuals or manual formatting. You can find more details in the official documentation on dynamic format strings for measures, which walks through this setup step by step.
Thank you.
