Forum Discussion
Measure as Category
Hi everyone,
I want use measure values as category in my pie chart. How do i do that?
I have a measure which changes value (Text) based on slicer selection. How can i use that as Pie Chart category?
Please help.
3 Replies
- Zubair_Muhammad
Community Champion
Anonymous
Please see if this post helps
http://www.excelnaccess.com/use-measures-in-slicers-rows-and-chart-axis/
- AnonymousNot applicable
Thanks for the link. But this one uses the measure itself as the categories, not the measure values, which I need. Could you help?
- Zubair_Muhammad
Community Champion
Anonymous
MEASURE is just a formula/SCALAR expression which returns a VALUE according to the EVALUATION CONTEXT (intersection of rows, columns, filters, slicers, categories etc).
VALUES are different when you change the EVALUATION context.
So there is no static list of values which can be used as CATEGORY or a COLUMN.
May be someone else has a solution