Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper IV
Helper IV

Calculations Based off A Field Parameter Selection

I have table visual that displays line times with a value columns for "Actuals" and a Field Parameter for two different types of budgets. Next in the visual I really want variance (Actual - Budget) and Variance % (Actuals/Budget -1) as the next two columns in the table. However I want the two variance columns to calculate based on the Budget field parameter selected. Is there a clean way to do this. I don't want to show want budget type, but accidentally show a variance on another budget type. I even tried using the field from the field parameter in the variance calculations but that did not work.

Any clean simple ideas?


Helper IV
Helper IV

I might be confusing myself to much and thinking it is more simple than i thought, but was confused in how to apply it to my case. I watched a few other videos and it seemed like several others noted that an extra column might be needed.

Super User
Super User

@asjones , In these two example I have used the selected value of field parameters


Switch TOPN with Field Parameters:
Field Parameters- Conditional Formatting:


Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors