10 Replies Latest reply on Jul 18, 2017 9:56 PM by Zhouyi Zhang

table formatting Colour

AJ.Yusuf Jul 17, 2017 4:11 AM

Hi Guys

Hope you are all well. I need a way to Jazz up and colour this table, Ideally colour the actual and absent rows. I have attached the workbook

Regards

colour table.twbx 58.8 KB

1. Re: table formatting Colour

Zhouyi Zhang Jul 17, 2017 4:19 AM (in response to AJ.Yusuf)

Hi, Junaid

Is this something you are after?

Please let me know if you have question

ZZ
Like Show 0 Likes(0)

Actions
2. Re: table formatting Colour

AJ.Yusuf Jul 17, 2017 4:45 AM (in response to Zhouyi Zhang)

Hi ZZ

Hope you are well. Yes but I dont need conditional colour jsut a more easy way of reading like highlight all abesnt in a defferent colour, coloumn lines etc. Just make it easier for a person to read this table
Like Show 0 Likes(0)

Actions
3. Re: table formatting Colour

Zhouyi Zhang Jul 17, 2017 5:19 AM (in response to AJ.Yusuf)

Like this?
Like Show 0 Likes(0)

Actions
4. Re: table formatting Colour

AJ.Yusuf Jul 17, 2017 5:28 AM (in response to Zhouyi Zhang)

Yeah Perfect
Like Show 0 Likes(0)

Actions
5. Re: table formatting Colour

AJ.Yusuf Jul 17, 2017 5:45 AM (in response to AJ.Yusuf)

Just the abset line in a different colour like this but this is done manaully
Like Show 0 Likes(0)

Actions
6. Re: table formatting Colour

AJ.Yusuf Jul 17, 2017 5:59 AM (in response to Zhouyi Zhang)

Can you send this
Like Show 0 Likes(0)

Actions
7. Re: table formatting Colour

Zhouyi Zhang Jul 17, 2017 6:02 AM (in response to AJ.Yusuf)

Hi, Junaid

Thanks for your sample, please follow below steps to achieve the highlight formatting.

Step 1, use separate color legends
Step 2, set Actual without any highlight format

Step 3: set Absent highlighting

Hope this could help.

ZZ
Like Show 0 Likes(0)

Actions
8. Re: table formatting Colour

AJ.Yusuf Jul 17, 2017 7:02 AM (in response to Zhouyi Zhang)

I dont have seperate colour formatting I am running 10.2
Like Show 0 Likes(0)

Actions
9. Re: table formatting Colour

AJ.Yusuf Jul 17, 2017 7:02 AM (in response to Zhouyi Zhang)

I mean Use Serperate Legends
Like Show 0 Likes(0)

Actions
10. Re: table formatting Colour

Zhouyi Zhang Jul 18, 2017 9:56 PM (in response to AJ.Yusuf)

Hi, Junaid

This is one of the new features since 10.2, below is a link of how to use it.

https://www.theinformationlab.co.uk/2017/03/01/tableau-10-2-legend-per-measure/

ZZ
Like Show 0 Likes(0)

Actions