Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Visual for displaying a large range of values

Hi Guys, I'm dealing with a sales dataset where sales of an item could range from 1000 to 1 million. Which visual or custom visual should I use such that the smaller values can be seen properly. I need something which shows the values as a percentage of whole (like pie,donut,treemap etc.)

2 REPLIES 2
quentin_vigne
Solution Sage
Solution Sage

Hello @vichu

 

If you want to display only the percentage of sale of this item, I would use Card box with automatic value and 2 or 3 decimals depending of the precision you want.

 

Example : 

 

You have 2450 sales, it will display 2.45K Sales or if it's 2450 sales on a grand total of 10000 it will display 24.5%

Card box are a good visual to use in my opinion

edejes2
Advocate IV
Advocate IV

Hello @Anonymous, 

 

This blog will help you in your decision https://eazybi.com/blog/data_visualization_and_chart_types/ 

 

Regards!

ED

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.