Power BI Chart Tips : Field Parameters Master Guide - KPI Switching + Dynamic Formatting with Just One Chart

When creating reports, we often face the same dilemma: "I want to see both Sales and Growth Rate—do I have to create two separate charts?"

The feature that solves this inefficiency in one go is Field Parameters. In this article, we will cover everything from switching multiple KPIs in a single chart to applying dynamic formatting, all in a practical way you can use immediately.

1. What are Field Parameters? (Conceptual Understanding)

When you utilize the Power BI Field Parameters feature in a chart, it allows the axis (X-axis) or values (Y-axis) to swap in real-time based on the selection a user makes in a slicer.

• • The Old Way: You had to create complex SWITCH function measures or overlap multiple charts using the 'Bookmark' feature.
• • The Current Way: Dynamic chart control is possible with just a few clicks, and maintenance is extremely easy.

As a result, this feature transforms a report from a "static visualization" into an "exploratory interface."

2. Creating a Dynamic Chart in 5 Minutes (Hands-on)

First, here is the sample data for 12 months for our practice.

Month	Sales	LY Sales
2024-01-01	105,000	98,000
2024-02-01	120,000	125,000
2024-03-01	155,000	140,000
2024-04-01	142,000	145,000
2024-05-01	168,000	150,000
2024-06-01	190,000	180,000
2024-07-01	210,000	205,000
2024-08-01	205,000	215,000
2024-09-01	198,000	190,000
2024-10-01	220,000	210,000
2024-11-01	245,000	230,000
2024-12-01	310,000	280,000

Step 1: Prepare Measures

Create the Sales and Last Year Sales (LY_Sales) data for Jan-Dec 2024. Then, create the following two measures:

• Total Sales = SUM(SalesData[Sales])

• YoY Growth = DIVIDE([Total Sales] - SUM(SalesData[LY Sales]), SUM(SalesData[LY Sales]))

Step 2: Create Field Parameters

1. Click the [Modeling] tab at the top > [New Parameter] > [Fields].
   
   
   
2. Name it 'KPI Selector' and drag the Total Sales and YoY Growth measures into the right-hand area.
   
   
   
3. Check 'Add slicer to this page' at the bottom and click [Create].
   
   
   

Step 3: Configure Visual Object (X-axis, Y-axis Setup)

Now, let's draw the chart and connect it.

• Chart Selection: Create a 'Clustered Column Chart'.
• X-axis Setup: Insert the SalesData[Month] field.
• Y-axis Setup: Drag the field from the [KPI Selector] table you just created directly into the Y-axis. 
  
  
  

If the X-axis of your chart appears cut off, it is likely because the axis type is set to 'Continuous'. In this case, go to the visualization format (brush icon) and change X-axis → Type to 'Categorical' to ensure all values are displayed uniformly.

Every time you click the slicer, the view automatically switches between Total Sales ↔ YoY Growth. In high-stakes reporting environments, it is common to have 10 or more KPIs rather than just 2 or 3. Field Parameters are not just an option; they are an essential design element.

3. Applying Dynamic Formatting

Applying Field Parameters to a chart introduces one problem: "Sales" should be displayed in dollars ($), and "Growth Rate" should be displayed in percent (%), but if the format is fixed to one, readability suffers.

The important point here is that you cannot apply a dynamic format directly to the Field Parameter column itself. This is because the parameter is merely a "pathway" to pass values, not the "subject" that determines the format. Therefore, you must apply the format to the actual measures that contain the values.

Setup Routine:

1. Click the source measure (e.g., Total Sales) in the [Data] panel.
2. In the top [Measure tools] > [Format] dropdown, select [Dynamic].
3. Change the dropdown to the left of the formula bar to [Format] and enter the formatting code appropriate for that metric.
   
   
   
4. Repeat the same process for the other measure (YoY Growth).

Now, when you select ‘Total Sales’ in the slicer, the $ symbol is applied, and when you select ‘YoY Growth’, the % symbol is applied automatically, significantly improving the chart's readability.

[Details on Dynamic Formatting – To be updated later]

[Tip for Space Efficiency: 'Double Switching' of X and Y Axes]

Field Parameters show their true power when applied not only to the Y-axis (values) but also to the X-axis (dimensions).

• Y-axis Parameter: Revenue vs Growth Rate vs Profit Margin
• X-axis Parameter: By Month vs By Region vs By Category

By combining two parameters like this, you can provide users with over 9 insights (3x3) using just a single chart. This is a powerful design approach suggested by Igloo BI that enables in-depth analysis without increasing the number of report pages.

Wrapping Up

Properly utilizing Field Parameters is not just adding a simple feature; it completely changes the structure of the report. Stop increasing the number of charts and start providing all insights through a single, dynamic chart.

Next Posting Preview: How to add your own identity to the reports you've meticulously built! I will be back soon with the 'Custom JSON Theme Creation Guide'.

I hope this article helps you in your Power BI practice. Please leave a comment anytime if you have questions!

<Other posts on the blog>

• Power BI Chart Tips : Power BI Visualization Strategy - Why Does Your Ribbon Chart Look Messy? How to Group by 'Other' While Keeping Only Top N

• [Power BI] DAX ALL Function Practical Series ② Ranking Part 3 : Relative Rank Index

• Mastering BLANK in Power BI [Part 3-2]: Solving "Ghost KPI Cards" & "Calculated Columns vs. Measures"

• Power BI DAX Integrated Analysis to Fix the Average Trap (Part 1-3): Segment Efficiency Integrated Analysis: Strategic Decision Report Based on EI-M and EI-R (A Power BI + DAX Approach)