Formatting requirement on Dashboard
Hi, I have a requirement where users want to have ability to add space line in rows for formatting purpose. I tried to use header formatting, add special character lineitem (such as --------) to do so... But none of them is accceptable by users. Second requirement is color in the list member. I tried to use conditional formating but users want to have color in list member (label/master data) also. Is there any improvment in near future on product roadmap that can let us to do these formatting requirement? Thanks a lot, Huy.
For now I do not see any option but we can try using Excel or PPT Addin and see if it helps, Addins are still in their primitive stages though.0
You can't have blank line items, or even line items with leading spaces in their names. All you can do is give them almost-blank names like . or - (i.e. a full stop or a hyphen).
There's also no way to change the colour of the line items names. Conditional formatting only works on cells with data in them (i.e. in the body of a table).
i know that "#------#" will work as a list item name.
Here is an example of a dashboard I mocked up to show hierarchical spacing. It required the creation of a mirror list, and a mapping between the mirrors. I'll illustrate:
1) Create a mirror List
2) Establish a list property linking the mirror to the original list
3) Execute a formula using the LOOKUP function0