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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Salle
Helper I
Helper 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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.