Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Reply
Salle
Advocate I
Advocate I

Group Measures as field parameters

New to using Field parameters - Is it possible to group field parameters?

Let say I have 3 products x 3 measures each I want to plot.
Product1

Measure1: Product 1 sales, Product 1 sales PY, Product 2, sales YTD
Product2:
Measure 1: Product 2 sales, Product 2 sales PY, Product 2 sales YTD
Product 3
Measure 1: Product 3 sales, Product 3 sales PY, Product 3 sales YTD.

I want to select only between "groups" Product 1 / Product 2 / Product 3 in a slicer tile which then shall dynamically change a combo bar/line chart on 3 different fields;
Y-axis (bar); sales
Y-axis (line1); sales PY
Y-axis (line2); sales YTD
X-axis (month)

 

Is the scenario above possible with field parameters feature?

5 REPLIES 5
nirrobi
Helper V
Helper V

There is 4 parameter in the field parameter that you can group measures inside the formula 

 

nirrobi_0-1708799109525.png

 

 

AGScottThompson
Frequent Visitor

Yes, Once you create your field parameter. Go to Table tools and select data groups and create your groups/

@AGScottThompson Thanks for the reply.

I was able to set it up (in Columns Tools > Data Groups) and got it working as either a line or bar chart (with the Field group as value and month on x-axis).

But is it also possible to use it for a combo chart, I want to visualize the different measures as either line or bar as shown below? Or do I need to set up the groups differently e.g. two different field tables (one for the line measures and one for the bar measures in the combo chart)?

Lets say I have 3 products x 3 measures each I want to plot.
Product1

Group1: Product 1 sales, Product 1 sales PY, Product 2, sales YTD
Product2:
Group 2: Product 2 sales, Product 2 sales PY, Product 2 sales YTD
Product 3
Group 3: Product 3 sales, Product 3 sales PY, Product 3 sales YTD.

I want to select only between "groups" Product 1 / Product 2 / Product 3 in a slicer tile which then shall dynamically change a combo bar/line chart on 3 different fields;

COMBO CHART 
Y-axis (bar); sales (group 1-3 depending on selection)
Y-axis (line1); sales PY (group 1-3 depending on selection)
Y-axis (line2); sales YTD (group 1-3 depending on selection)
X-axis (month) 

 

How did you group in the field parameters?

As I am not getting option to group it.

Could you please provide some snapshots? Thanks!

@SumitPandey 

This was the way I used it for line chart, I have not gotten it to work in a combochart as I´d like to.

1) First create your field parameter with your measures

Salle_0-1694028338838.png

>>> It creates a table with the following content

Salle_1-1694028379433.png

2) Select the column in the Table created

Salle_2-1694028406167.png

3) Under menu "Column tools" select "Data groups" and set up the groups and name as you prefer

Salle_3-1694028443912.png

4) Add the group in a slicer and the table column (field parameters) in the line chart.

Salle_4-1694028480690.png

Hope it helps!

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.