Blended Axis in
Tableau
It is also called as combined axis or shared axis chart.
In Tableau Blended Axis we combine & analyze more than two measures together in a multi line graphs or charts. So that we can plot as many measures as we like in the same chart.
In Blended axis all the measures are shown on single axis.
So in blended Axis all measures have same marks cards and same scale.
It is useful in comparing measures with same data type and scale.
For Example , Sales ,Profit, Budget etc.
How to create Blended Axis chart in Tableau method 1
1 To create Blended Axis Chart first we create graph for any single measure among many measures that we are analyzing.
2 Then drag second, third and other measures we want to add one by one & blend it in first axis of the measure to create a graph with multiple measures blended into one axis.
3 Our single blended axis with multiple measures will holds all the range values from the source of all the measures which are blended in to one axis.
4 At this point name of the axis changes to ‘Values’.
5 Here all the measures will have only one marks card . i.e. if we change it to bar then bar is for all the measures ,if you change it to line then line is for all the measures.
How to create Blended Axis chart in Tableau method 2
1 To create Blended Axis Chart first we drag and drop column value that we want in to column.
2 Now in second step, if you look at the left side in measures list we can see ‘measure values’, In 'Measure Values' all the measures combined into one measure.
3 Drag this 'Measure Values' into rows .
4 You can see all the measures in our graph but we don't want these many measures so simply remove all the unwanted measures from measure values section .
5 If we want to analyze only sales and profit then keep these two measures only in the list.
6 Here our blended axis graph for sales and profit is ready .
I hope that this helps you to understand how to create Blended Axis Chart in Tableau.
You can also visit my channel to watch video of how I created Blended Axis Chart on sample data set.
https://www.youtube.com/watch?v=Bvc9SMm78iE
Please comment below if you need information on any other topic in tableau.
No comments:
Post a Comment