Skip to main content
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: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

0

Bug: Value formatted as % not displaying properly in Sparkline

Submitted by Anonymous 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:
2 Comments (2 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

pmay
Resolver I
Resolver I
‎01-11-2024 04:02 AM

This isn't delivered, it is still broken.

pmay_0-1704973890014.png

The sparkline is based on the measure for Inbound Conversion, the measure divides the number of successful sales by sales opportunities, which are columns in my table.  The measure is formatted as a Percentage:

pmay_1-1704974037900.png

The same problem occurs when a value is formatted as currency - it seems the tooltip for Sparklines simply doesn't see what format you've set for the source measure.  It looks to me like the sparkline is actually an implicit measure created by PowerBI when you add it, with no option to customise the format.  I'll have to turn tooltips off until Microsoft fixes this bug.

 

PS: I'm on December '23 release of PowerBI Desktop.

Idea Statuses