search

Profitbase / PowerBI-visuals-FinancialReportingMatrix

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

Row percentages (Variance) #583

Closed castrofg closed 2 months ago

castrofg commented 2 months ago

How do I deduct a percentage/ formula for (5)% - 3%. Right now it's calculating the above numbers. I'm trying to deduct "Actual - Budget" which equals Variance. I also need to include "Var %" = (Variance / Budget)

I also need the percent sign inside the parenthesis, somehow it's outside ie (5%)

image

Percent outside parenthesis sample: image

Thanks

AndersAano commented 2 months ago

Hi @castrofg, you would need to do something like this: Right click the column where you want this. then select "Add column formula".

In the formula, you could add this:

image

C = Condition T = True F = False

This is checking the value of the measure. If it's greater than 0, leave it as is. If it's not greater than 0, then us the FORMAT function:

Format(MEASURE,"(0%)")