The logic behind the true false condition in the dashboard uses the field of tableau which always indicates the total number of available records within a worksheet when aggregated.

Create a calculated field Filter Highlighter, add the following code to display the text when the filter is selected.

Add a new worksheet in tableau, this sheet will highlight the text when the user selects any filter on the dashboard.Here is a cool trick to do that using worksheet, field and LOD is tableau. But wouldn’t it be cool if you make it much more interactive letting the user know that filters are applied. One cool way to interact with tableau dashboards is to apply filters and see only the categories you wish to see on tableau dashboard. But make sure to check how it looks on the dashboard, certainly some part of the worksheet columns will be trimmed.

Now you can use any number of columns on row self in tableau worksheet, in this case 24 is the maximum number. After packing it, make sure the workbook file has. twbx file using unzip utility: winzip in this case. Now search for the code as highlighted below and change the value to desired number, 24 in this case. twb file using any xml editor : notepad in this case. twbx tableau workbook using any unzip utility. twb workbook file which contains the xml code. What if you want to show more than 16 columns in the row shelf? Well that’s possible with hack but tableau doesn’t recommend you playing around with its xml code as it would mess up with the workbook. Now you can extend the number of columns in the row shelf up to 16.

To do that go to the analysis option at the top menu bar-> table layout-> advanced. We can easily extend it to include up to 16 columns. any more dimensions when included, tableau clubs them with a comma. The default number is 6 for number of columns at the row level. But tableau is flexible enough to allow you to create report with up to 16 columns within worksheet. Although someone creating dashboards would never suggest user to create a tabular report with such huge number of columns, excel is much better choice than tableau in this case. Many a times, users just want to see a report in tabular format with 16 or more columns.

Downgrade tableau desktop 10.1