Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
There is 4 parameter in the field parameter that you can group measures inside the formula
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
>>> It creates a table with the following content
2) Select the column in the Table created
3) Under menu "Column tools" select "Data groups" and set up the groups and name as you prefer
4) Add the group in a slicer and the table column (field parameters) in the line chart.
Hope it helps!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.