Forum Discussion
Advocate Iis a custom visual input measure a percentage format?
Hi - i have been trying to find a way of discovering if a selected measure passed into a custom visual is of a percentage format or not.
Does anyone know where in the VisualUpdateOptions object that would be? It doesn't seem to come through on the
- categorical:
- values: Array(1)
- 0:
- source:
object.
Hi jonespossibly,
With percentage, there is no explicit type for it. They are just regarded as numeric, so the only way to be able to determine would be through the format string, either:
- Under metadata.columns and the associated entry), e.g.:
- For categorical, as per your OP, e.g.:
For all data view mappings, each array element should have a source property that will contain a format string if it has been set in the data model. If this is not present then it will not have been explicitly set. If a column or measure has been set as a percentage type, then it should indeed show an appropriate format string to that effect.
If there's no format property present, you can only use the source.type property to try and derive the data type, but IIRC percentage is only stored as a numeric here, as there is no explicity type to denote, e.g.:
Note that date columns can potentially contain percentage characters in their format string, e.g.:
There could be other cases to consider, but combining a type.numeric === true along with checking the format string might be okay.
Hopefully gives you some ideas. Good luck!
Daniel
- Under metadata.columns and the associated entry), e.g.:
1 Reply
- dm-p
Super User
Hi jonespossibly,
With percentage, there is no explicit type for it. They are just regarded as numeric, so the only way to be able to determine would be through the format string, either:
- Under metadata.columns and the associated entry), e.g.:
- For categorical, as per your OP, e.g.:
For all data view mappings, each array element should have a source property that will contain a format string if it has been set in the data model. If this is not present then it will not have been explicitly set. If a column or measure has been set as a percentage type, then it should indeed show an appropriate format string to that effect.
If there's no format property present, you can only use the source.type property to try and derive the data type, but IIRC percentage is only stored as a numeric here, as there is no explicity type to denote, e.g.:
Note that date columns can potentially contain percentage characters in their format string, e.g.:
There could be other cases to consider, but combining a type.numeric === true along with checking the format string might be okay.
Hopefully gives you some ideas. Good luck!
Daniel
- Under metadata.columns and the associated entry), e.g.: