How to reformat the numbers in Key Influencers visual

[Anonymous]

Hi, 

How do I format the metric numbers in the Key Infuencers visual? For example, my visual explains "when sales decrease by 78567876 the cost decreases by 1.2M" The first metric is not defined. How do I change the format for the first metric to show currency or a specific category? Right now, it is showing a stream of numbers. 

Thank you.

[Anonymous]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your onedrive business.

Best Regards,

Rico Zhou

[Anonymous]

Hi @Anonymous 

Just like amitchandak replied before, you can reformat the numbers by column tools or you can try my way.

In model view:

Or you can change type in power query editor

Or you may want to change Display units:

If this reply still can’t help you solve your problem, please provide me your data source, the visual of the result you want ,the visual of the problem or share me with your pbix file from Onedrive for business.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[amitchandak]

@Anonymous , have set default number format.