cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
proreporter Frequent Visitor
Frequent Visitor

How to Show Tags in % Format

Hello community,

 

I come up with an easy question: I'm trying to show the information inside a chart in percentaje but PBI only allows me to show the information in Units/Thousands/Millions, etc.

 

The 2 columns shows the information in numeric format with decimals and I use a normal Division "/" and with the formula DIVIDE offered as solution in the link below:

http://community.powerbi.com/t5/Desktop/percent-change/m-p/45572#M17711

 

I guess it is really easy to solve but I'm missing something (also the search bar of the forum didn't offer me more solutions).

 

Thank you handsome gentlemen,

1 REPLY 1
Dog Established Member
Established Member

Re: How to Show Tags in % Format

Hi, 

 

If you have created the measure through Power BI itself then you could format the output

 

TestMeasure = FORMAT(DIVIDE([Debit], [Credit]), "0%")

or high light the measure and select the Modeling tab - you can set the format there. 

 

 

or if you are using visual studio to manage your model then you can change the data type to Percentage. 

 

Hope this helps.