cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
0
Kit

Bug: Value formatted as % not displaying properly in Sparkline

Submitted by Helper I on ‎09-01-2022 04:48 PM

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.

 

Kit_0-1662075804973.png

Kit_1-1662075804968.png

 

 

Status: Delivered

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:

vyingjl_0-1662105328416.png

 

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.

vyingjl_1-1662105484458.pngvyingjl_2-1662105509048.png

 

Best Regards,
Community Support Team _ Yingjie Li

See more ideas labeled with:
1 Comment (1 New)
Comments
v-yingjl
Community Support
Community Support
‎09-02-2022 12:59 AM
Status changed to: Delivered

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:

vyingjl_0-1662105328416.png

 

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.

vyingjl_1-1662105484458.pngvyingjl_2-1662105509048.png

 

Best Regards,
Community Support Team _ Yingjie Li

Idea Statuses