Forum Discussion
Advocate IGroup Measures as field parameters
Advocate IAGScottThompson 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!
- Salle
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!