I want this to be displayed in a Bar chart with colours. For Ex :
For a particular parameter, how many are pending, Fixed and Identified. Here, X axis should have parameter names listed, Y axes should have a Bar with total number of identifications made in that parameter along with the bifection how many are fixed and Pending highlighted in different colors. So we will have a bar with Identification (Blue), Fixed (Green) and Pending (Red) for each parameter.
For solving this you do not require a calc field at all, make use of Blending Axes in this case.
1. Drag Measure Value to Filter shelf
2. Select Fixed, identified and pending
3. Keep Measure NAmes from dimension in Colour Shelf
4. keep Parameter in column '
5. drag measure values from measure shelf to rows.
Your job would be done
Please let me know if it helps
F2.twbx 13.9 KB
Okay.. ! You need show it in stacked bar by Parameter. Is this your requirement?
1.Then you need to drag & drop Measure value in Rows and Parameter in Column.
2.Keep required measure and remove unwanted measures.
3.Drag Measure names into Colors.
Since your excel have only one value in parameter it is showing single stacked bar.
Let me know if your requirement different than what I understood