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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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