John Nickell on 02 Nov 2021 15:54:20
Please enable us to use hidden measures as an option for conditional formatting a column. At present it looks like you can only use 'visible' measures to provide conditional formatting.
If we have a measure that it's sole purpose is for providing conditional formatting key, it would be nice to not have it cluttering up the available list of measures of the fields view.
For clarity this is the experience when using a report linked to a live dataset. If the measure is hidden at the dataset level it is unable to be used in conditional formatting rules on the report. And because it's hidden on the dataset level, it's unable to be unhidden in the report.