Skip to main content

Power BI

Needs Votes

dimension description template

Vote (2) Share
Martijn van der Jagt's profile image

Martijn van der Jagt on 12 Sep 2019 18:26:12

It would be very useful to add a 'dimension description' page for most used common dimensions. This would complete the dimensional modeling (as by theory) of nominal, ordinal, categorical (etc) dimensions.

Examples
- A dimension can have a preferred sort order (by name, by attribute, by measure)
- A dimension can be numeric, but still ordinal (average and additions not applicable), and the basic interpretation is 'string with numbered sort orders'
- A dimension can be non-additive (average numbers) or non- multiplicative
- A dimension can be numeric with labels (e.g. driving distance with road exit names)
- A dimension can be date (or datetime) with specific events (to be used as labels)
- The values in a dimension can have specific behaviours, like color when used in column series.