Can't change Format for Measure

[YusufGillani]

Hi,

I am working on a video tutorial called Dynamic Visualisation Techniques in the Financial Reporting W/ Power BI and I can’t seem to change the format of a particular measure. Do you know why this is? Please see screenshot of the measure I am working on and you can see the Formatting is greyed out.

Any help would be much appreciated.

Thanks

Yusuf.

[Harsh]

Hello @YusufGillani,

Thank You for posting your query onto the Forum.

Well, the formatting part is greyed out because you’ve used the “FORMAT()” function in your measure. Once you use this function it converts the figures into the text format by default and sets that format. Second thing is, within that as well you’ve incorporated two different formats i.e. one for “Number” in terms of “0.00” and one for the “Percentages” in terms of “0.00%”. Due to use of “Characters” as well you won’t be able to change the formatting by using the “Format” option available under the “Formatting” menu.

Sam in his videos as well has agreed that once you use the “FORMAT()” function the figures will get converted into the “Text” format and then formatting cannot be changed by using the normal option.

I’m also providing few links below where similar sort of queries were being asked onto the forum as well about the formatting and what sort of solutions were provided to them but the sort of solution that you’re looking for is currently not achievable due to the usage of “FORMAT()” function.

Hoping this helps you.

Thanks and Warm Regards,
Harsh

Variance column when comparing %ages

Hello @Stuart, Since you’re calculating only the % figures, you can try by removing the “FORMAT()” function from your measure and then you can simply apply the % formatting by selecting it under the “Measure Tools” option. In that way, you can still have the answer in terms of %. After this, you can simply calculate the measure for the Variance Analysis by subtracting this year totals with the last years. Because in this case, by applying the “FORMAT()” function you’re converting the numbers …

Bar chart with changes between absolute number and %ages

Hi I created a bar graph that is linked to a slicer for various KPI’s, that works well. The only issue I have is the data labels (i.e. when I select a slicer that is a %age, the data label shows as “0”, when I need it to show as a %age. [image] I have tried formatting these to %ages both in the slicer calc and the initial calc, with no success. Any idea how I can fix this? Kind regards Stuart