Hello,
In DAX (in Excel power pivot) you can create non numeric measures and display it in a pivot table.
For example a dynamic measure called STATUS, that return « SURPLUS » if the sum of values is POSITIVE and return « DEFICIT » if the sum of value is NEGATIVE.
I can easily add it in the pivot table and see the result, split by positive/negative.
But what if I want to use this text measure in power view ?
- in a table
- or as a color category in a map ? To be able to colour differently bubbles in SURPLUS or in DEFICIT.
The measure is not available in the table in the powerview sheet
Did you have already this kind of need ? How could I tackle it?
Thank you for your help.
In DAX (in Excel power pivot) you can create non numeric measures and display it in a pivot table.
For example a dynamic measure called STATUS, that return « SURPLUS » if the sum of values is POSITIVE and return « DEFICIT » if the sum of value is NEGATIVE.
I can easily add it in the pivot table and see the result, split by positive/negative.
But what if I want to use this text measure in power view ?
- in a table
- or as a color category in a map ? To be able to colour differently bubbles in SURPLUS or in DEFICIT.
The measure is not available in the table in the powerview sheet
Did you have already this kind of need ? How could I tackle it?
Thank you for your help.