@@TableauTim Hello Tim I had a go at the question I posed and came up with a solution, the fundamental part is the calculated field and tweaking the SetAction. 1) Created a calculated field called [Category Set colour] if [Category Set] = True then [Category] Else '000 remainder' End 2) Use [Category Set colour] as the colour on the bar chart 3) Create the dashboard with the pie+bar and create the same set action EXCEPT that "Clearing the selection will" = "Remove all values from the set" 4) Once you use the action you'll be able to change the colour of '000 remainder' to your very light blue colour.
It’s built into Tableau. It’s the native tableau colour palette picker. help.tableau.com/current/pro/desktop/en-us/viewparts_marks_markproperties_color.htm There are two types of colour. It’s linked to discrete vs continuous fields. Blue and green fields.
Hey Tim, Great tip! This seems like a great way to filter existing categories for a proportional view. I watched something similar on Playfair data and was wondering if there’s an easy way to use just the category labels as a filter instead of using the pie chart, would love to see a version of that!
Could build a much simpler chart using Squares. The action has to come from another visulisation so it could just a be a coloured table thats formatted to look like a selection bar.
Hey Tim, When applying this to my project, I went back to the chart and under the IN/OUT set Marks I only had "In" and no "out" so I am unable to change the color of the "out" data. How do I fix this?
Awesome. Thank you for this
Hey Tim, This is an wow trick! ❤️
Hello Tim, thanks for this video 🙂
Is there a way that the same clour of the pie segment you choose is show on the bar chart (instead of the pale blue)?
I think so! in my head i have an idea ahah. I'll try it first
haha, same thought here ...
@@TableauTim Hello Tim
I had a go at the question I posed and came up with a solution, the fundamental part is the calculated field and tweaking the SetAction.
1) Created a calculated field called [Category Set colour]
if [Category Set] = True then
[Category]
Else
'000 remainder'
End
2) Use [Category Set colour] as the colour on the bar chart
3) Create the dashboard with the pie+bar and create the same set action EXCEPT that "Clearing the selection will" = "Remove all values from the set"
4) Once you use the action you'll be able to change the colour of '000 remainder' to your very light blue colour.
Thank you for sharing!
Hi! What was that color pallet tool you pulled up? Love it and need it!
It’s built into Tableau. It’s the native tableau colour palette picker. help.tableau.com/current/pro/desktop/en-us/viewparts_marks_markproperties_color.htm
There are two types of colour. It’s linked to discrete vs continuous fields. Blue and green fields.
Hey Tim,
Great tip! This seems like a great way to filter existing categories for a proportional view. I watched something similar on Playfair data and was wondering if there’s an easy way to use just the category labels as a filter instead of using the pie chart, would love to see a version of that!
Could build a much simpler chart using Squares. The action has to come from another visulisation so it could just a be a coloured table thats formatted to look like a selection bar.
This is really a great tip! Do you know how the performance is vs a traditional set filter?
Hey Tim,
When applying this to my project, I went back to the chart and under the IN/OUT set Marks I only had "In" and no "out" so I am unable to change the color of the "out" data. How do I fix this?
Never mind I figured it out. Thank you for all of the quality tutorials
Glad you solved it
Hello Tim, how u are draw this lines acros screen? What is it?
See the description of the video for everything I use to record :D >> ruclips.net/video/BzNeBaFzUVE/видео.html
That is very similar to what Tableau prep do when we select one dimension.
Nice one.
this is slick, couldn't it be done with an LOD of total sales & a dual axis? may be simpler.
Try it :D always more than one way but an LOD wouldn't be dynamic for the selection.