Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Symptoms:
Create a Stacked Column Chart with text-based X-axis values or numeric X-axis values in Type Categorical mode.
E.g.:
- Text: r1801, r1802, r1803 ... r1812, r1901, …
- Or numerical: 1810, 1811, 1812, 1901, 1902, … in Categorical Type of PBI
When a total number of datapoints in all columns is below about 130, then everything's fine.
When the number of datapoints exceeds this threshold, e.g. a new column added or more datapoints are added to existing columns, then:
- 'Too Many Values' notice is displayed
- displayed results become unreliable, because datapoints are 'stolen' from existing columns in order to accommodate the overall number of 130; as a result some columns displayed correctly before adding new datapoints become 'smaller' for no obvious reason (!).
Notice:
This behavior does not occur if:
- with text X-values the overall number of datapoints is lower than about 130
- numerical X-values are used in Continuous Type of PBI, e.g. 1810, 1811, 1812, 1901, 1902,… – but then naturally 1812 column is separated by a large void space from 1901 column.
Please help to fix this issue as it makes this kind of reports unusable for our organization.
Kind regards,
Marcin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.