The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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,
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.