Formatting requirement on Dashboard

Previous Contributor

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.

Super Contributor

RE: Formatting requirement on Dashboard

Hi 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.
Regular Contributor

RE: Formatting requirement on Dashboard

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). Sorry.
New Contributor

Re: RE: Formatting requirement on Dashboard

Hi Huy,


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 function