Wanting to have the block change to a light red while the figures go dark red when the numbers go negative.
Dear Jack Footer,
you mean something like this ?
This is no standard function of the dataview itself. To get it work, you need 2 DataViews overlaying each other.
For the one in Front you enable the transparency (in my case to 30%)
In my case, the one in the front displays the background color and the one in the back the figures color.
Hope it helps.
regards
Alexander Kappes
The title of this Idea is relevant for what i'm trying to do. I currently have a colour alert changing the background colour of the cells based on a cube flagging actual weeks. I also want to change the colour of the font to Red if they're negatives but otherwise remain as black. Is there a way to do both? Thanks
Hi @Lewis Wright,
As far as I'm aware, no. Color Alerts define the entire cell style (background, font, etc.), so there wouldn't be a way to layer two alerts where one controls the background and another controls only the font.
That said, you could achieve something similar with a workaround by layering two Data Views. The base Data View would contain your background color alerts and be formatted as you normally would. Then, you would place an identical Data View on top, but configure it so that all formatting is effectively hidden (headers, cell backgrounds, borders, text color, etc.), leaving only the font color driven by the Color Alert.
In this setup, both Data Views would be identical in terms of layout and data. The only differences would be the Color Alerts applied to the top Data View and the transparent formatting used to hide everything else. It's not a perfect solution, but it could get the job done if combining background and font color alerts is a critical requirement.
One word of caution: you'll need to keep sorting and selections synchronized between the two Data Views whenever changes are made. Drill-down also requires some additional consideration. One option would be to simply disable drill-down, and have this as a view-only report. Another option if drill-down is important is to have the top Data View overlay only the values area, leaving the rows and column headers of the base Data View available for interaction. Alternatively, you could reverse the approach by setting the text color (from the Design tab) in the base Data View to transparent while keeping the text in the top Data View black. Since the top Data View is the one being clicked, this would allow the row entity members to display correctly in the drill-down, while the base Data View simply provides the background color alerts.
See the screenshots below for reference:
Final result: both Data Views layered to combine the background and font color alerts.
Color Alert configured on base Data View (style: cell background).
Color Alerts configured on the top Data View (style: font color)
Top Data View Design formatting (all item Colors set to transparent, including object Text font)
Let me know if you have any questions.
Kind regards,
Hamza
