Creating Parameters in Power BI

A parameter in Power BI is a named value or set of values that can be referenced in expressions, queries, filters, and various calculations within the Power BI Desktop. This feature allows for the user to explore and customize the analysis of the report by selecting the different measures or dimensions they're interested in.

Use Case: Referencing sale values to target values:

Parameters can be used to create dynamic filters that allow users to change the filtering criteria interactively

Creating Parameters:

    • Modeling tab > Parameters > Numeric Field (image above use this option) or Fields> Select your range for the Parameter slider> Create
    • The Parameter box should appear on your canvas.
    • Adding the parameter to your chart... Select Chart > Visualization pane and select Analytics > Constant Line 'Add' > Line > 'fx' Function > Format Style 'Field Value'> Field based on 'Parameter you just created' > OK

For further analysis see my previous blog on : Colouring Bars Using DAX

https://www.thedataschool.co.uk/alexandra-skelly/colouring-bars-using-dax-in-power-bi/
Author:
Alexandra Skelly
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab