Profitbase / PowerBI-visuals-FinancialReportingMatrix

Power BI Custom Visual for Financial Reporting
65 stars 23 forks source link

Formatting a percentage in a formula #579

Closed castrofg closed 2 months ago

castrofg commented 2 months ago

I'm currently using the formula below but it shows as (0.08751453451339). But, I need it to show up as (8%).

I'm alraedy using the Formatting Value for the "Negative values format" for my other measures, but it's not working for this current formula.

Formula: IF(RowHeader()=="Total Revenue", Month Variance / Month Budget, Month Var %)

How do I format the above formula to show as my attached image? Thanks

image

AndersAano commented 2 months ago

Try adding a new step with "Add column formula" for your %-column:

Format(Diff %, "#.#0%")

Before:

image

After:

image

best regards Anders