Hi Drew, I'd do something like this:
In this view, I clicked the right arrow on the Brand pill and chose "Sort" from the menu to show the Sort dialog box. Here, I chose to sort descending by the Field "Is Priority" (the aggregation can be anything at all). This has the effect of making the bottom axis show the Priority brand in the left-most position.
Hope this helps,
P.S. You can also manually do these groupings and logic in Tableau, but if you have access to your data source (Excel) and it seems that you do, it makes more sense to do it there.
PriorityBrand_v10.2.twbx 20.6 KB
Very helpful Jennifer, thank you! Related question, is there any way to have the "Null" not appear in the Priority Link Filter on the right-hand side? As to prevent the user from pulling up all that other data?
1 of 1 people found this helpful
If you won't use those null values anywhere in your dataset, you can exclude them at the datasource level. On the Data Source tab, go to Filters at the top right of the screen, click Add, choose Priority Link, set the filter to Exclude Null, click Ok.
And you have this:
If you need those nulls in your data for other views, and just want to exclude it on this sheet, I would duplicate the Priority Link field, add it to the filter card on this view, Exclude Nulls, and set the Priority Link filter to "Only Relevant Values".
2. Add to the Filter shelf and Exclude nulls
3. Set Priority Link Filter to Only Relevant Values
Fantastic, thank you for the thorough help, really appreciate it!