Forum Discussion

proreporter's avatar
proreporter
Regular Visitor
9 years ago

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,

Need Help
Tips and Tricks
Tutorial Requests

1 Reply

  • Dog's avatar
    Dog
    Responsive Resident
    9 years ago

    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.