Data Formatting in Financial Reporting

Hello @lulumoon,

Thank You for posting your query onto the Forum.

Well the similar type of queries had been asked onto the Forum where members had tried to format the percentages (%) as well as the numbers within the same measure. But truly speaking as of today, there’s no way around of it. Power BI doesn’t allow to format two different variables or types within the same measure.

Sam had also agreed in one of his “Learning Summit Series” videos of Financial Reporting where a live query was asked by a member and he said that there’s no option. The only thing that you can use is “FORMAT()” to format the percentage % figures. And he also said that once you use this function the figures gets converted into the Text.

I’m providing a link below of the queries asked by the members onto the forum and the solutions provided to them.

I’m attaching the working of my PBIX file on Financial Reporting for the reference. (If it helps any).

Hoping you find this useful. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

Income Statement and Balance Sheet - Harsh.pbix (859.9 KB)