Decimal value formatted as percentage is displaying correctly when used in a table. However when used to create a sparkline, when you hover the mouse over the sparkline the tooltip is displaying the value as a decimal number rather than as a %. Can you please fix this.
As far as I know, it should depend on data type instead of data format in Power BI Desktop since it shows as decimal number in your post:
In Power BI Desktop, percentage is used as a format not a type, even if you changed the data type in Power Query editor from decimal number to percentage number, after applying and closing Power Query to load data into Power BI Dekstop, the data type of the column is still decimal number.
Community Support Team _ Yingjie Li