Hello, I have a BAQ associated to a dashboard. Running the BAQ all cells are grey background like usual.
But when I use it into a dashboard, some of the text column cells with no data are all black background. !!
How do I make sure it behaves same as in the BAQ?
Instead of directly displaying fields that could be null, use a calculated field that is defined as ISNULL( fieldname, ’ '). Dashboards display nulls differently than blanks, by setting a field to convert nulls to blanks, you will get the result you are looking for.
