UKanExcel (Mark Robinson @ Cloud2 Ltd) on 07 Sep 2017 16:20:28
It would be useful, particularly in the creation of Report Templates, if formatting options could be applied to a data visualisation before data is applied to the data visualisation. Currently all formatting options are greyed out until data is applied.
- Comments (2)
RE: Apply formatting to a data visualisation before data is added to it
Tend to agree, although what are the scenarios where "no data" will actually allow most visualisations actually show anything ?
There is a specific example that does not seem well catered for with data i.e. there's no way to specify the default data colours in a visualisation with NaN value.
Data colours can be linked to a value.
The values can become NaN under certain conditions.
The default data colour when NaN currently maps directly on to the existing user value range (min, centre, max).
NaN is however out of scope of the range.
It would be very useful if the user could also provide a colour and/or some other settings for NaN.
As it is, the user now sees (on my visual) the maximum value colour for NaN. This is not correct and veyr misleading.
Complex work arounds may exist, but there are diminishing options given the current way in which computed columns, measures in context and visualisation control parameters are set up.
RE: Apply formatting to a data visualisation before data is added to it
We have developed a number of PBI Report Templates, 12 in total, so I think we and the wider market would benefit from this idea.