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

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

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
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

May Power BI Update Carousel

Power BI Monthly Update - May 2026

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

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.