Ciara Brennan (Tableau)
cc'ing @Zach LeDoux (Tableau) as fyi
While I'd like to keep by default the current behaviour of column widths of text tables, it would be nice to also have the option to:
1. Fix the width of each column individually
2. Add a "Fit to content" option
In many cases, I design my dashboards so that I have sufficient screen real estate and do not need to "shrink" my text tables. In this case, the current behaviour works well.
But in those cases where I do need to display quite a lot of columns, being able to reduce the width of the ones containing less characters (ex: single digit integer with short alias name) would make my dashboard a lot clearer.
Duplicate idea(s):
***********************************************************************************************************************************
--> Update Jan 15 2019 Note courtesy of Harveen Kathuria
Hello Tableau Community,
My name is Harveen, and I am a new Product Manager at Tableau. One of the areas that myself and the team are looking into is improvements we can make to tables.
We review all the ideas shared on the community forums and sincerely appreciate your feedback. Our plan for tables is still under development.
In addition to reading the feedback here, we have held several 1:1 conversation with customers on their needs for tables and we will continue to do so.
We welcome continued feedback on tables either here or in a 1:1 conversation that we can set up.
Just send me a direct message or reply to this comment. (For more information on direct messaging refer to this post:https://community.tableau.com/thread/201756)
Regards,
Harveen
***********************************************************************************************************************************
Ciara Brennan (Tableau)
cc'ing @Zach LeDoux (Tableau) as fyi
When will this be implemented in Tableau Desktop?
There are requests for this functionality stretching back to 2015 (perhaps further) unfortunately.
Being able to dynamically format numbers on multiple measure values would be incredibly helpful. Here's hoping the Tableau team can do something about this in the next 7 years 😳
Any chance this will happen this year?
Functionality will certainly enhance adoption, improve turnaround and functionality of tables - which are commonly required, particularly as we guide people here from excel.
Thank you all for your continued participation in this discussion.
Please help us improve Formatting by taking this survey to share your experiences and feedback with the Tableau Formatting Team!
As a thank you for participating in our survey, we will give three randomly selected participants a $50 gift card to the Tableau Gear Store. To be entered into the drawing, you need to complete the survey by January 21, 2020, and provide your e-mail address in the designated location. Only one entry per person. You do not need to give us your e-mail address to complete the survey. We will store and use your e-mail address only for determining the winner of the giveaway and in all cases in accordance with our privacy policy located at https://www.tableau.com/privacy.
Nick Parsons
PM, Formatting
I'll chime in with my 2 cents.
I need to build a table in Tableau to replace an obsolete Excel report in Tableau. The data is hard to force into the table layout (discrete measures, etc.) and now I need to replicate the Excel conditional formatting. One section needs to shade negative cells red, and another needs to shade cells yellow if the value is close to a calculation of limits. Trying to get this in Tableau right now is impossible, and I'm stuck.
Looking at the dashboard layout pane, I can see an obvious place to put conditional formatting, from font color or size to background color. The calculation would be based on the displayed values, and could be set up for columns, ranges of columns, rows or ranges of rows.
It doesn't look hard to me, but this issue has been a pain point for SEVEN years at least! So many versions of Tableau, but no solution to this. Can someone tell me when this will be fixed?
Thanks.
Hi Jakob,
Sorry for the late reply and I have no idea if you have found other solutions.
I have similar solutions:
If you want to add separate color to different columns, drag "Measure Names" to Color Tab, then right click Measure Name and select "Use Separate Legends", then you have to manually set color for every column. A little tiresome but workable.
For the the arrow format, you can customize the number format of that column to "▲#,##%;▼#,##%;" and any positive number will have a ▲ in front of it, vice versa.
https://playfairdata.com/ten-tableau-text-tips-in-ten-minutes/
Request that Tableau please benchmark against Excel. This feature is super easy in Excel and Tableau should strive to be at least as easy. Otherwise, the labor cost is too high and inflates the total cost of using Tableau. Also, being that Tableau specializes in data insights, conditional formatting is a Sina qua non for many of us. Thank you
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.
HI @Ciara Brennan (Tableau) do we have any update on the custom number format in Billion, Million, Thousand and Units? We cannot always use the customer string method
Still awaiting solution for my questions https://community.tableau.com/s/question/0D54T00000n7CMCSA2/in-a-crosstab-table-i-want-to-format-numbers-dynamically-based-on-values-in-b-m-k-units-and-b-m-k-0-this-includes-multiple-measures-in-one-view