Show color bar even when no data in bar chart

0 votes
How to show color for bars in a stacked bar chart even if no data or zero value for the calculation or measure is present?
May 9 in Tableau by Latha
23 views

1 answer to this question.

0 votes

Hi Latha,

Follow the below steps:

1. Create the bar chart as required. ( For ex. below)

2. Craete a calculted field with any constant value or create a fixed avg(measure).

3. Now add the created field in the sheet.

4. Now make a dual axis chart.

Thus in the above chart green color shows no value or zero.

Hope it helps you.

answered May 9 by Cherukuri
• 25,700 points

Related Questions In Tableau

0 votes
1 answer

Want to hide the Bar for Grand Total in the bar chart in Tableau

Tableau treats the whole visualization uniformly.  If you ...READ MORE

answered Aug 10, 2018 in Tableau by AwesomeSauce
• 860 points
550 views
0 votes
1 answer

How to show % difference between bar chart to show increase or decrease?

Hi Anshuli, Make the bar chart first for ...READ MORE

answered Apr 5 in Tableau by Cherukuri
• 25,700 points
64 views
0 votes
1 answer

Total vs partial in a bar chart

Hi Sindhu, Follow below steps : 1. Select fields total ...READ MORE

answered Apr 17 in Tableau by Cherukuri
• 25,700 points
51 views
0 votes
1 answer

How to show % of the total to each bar in bar graph?

Hi Manu, It is a simple procedure, Follow ...READ MORE

answered Apr 22 in Tableau by Cherukuri
• 25,700 points
43 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,793 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
76 views
+2 votes
1 answer
0 votes
1 answer

Displaying Aggregations across bar chart in Tableau

Hi Sindhu, 1.You can use average lines to ...READ MORE

answered Mar 8 in Tableau by Cherukuri
• 25,700 points
50 views
0 votes
1 answer

How to show percentages on the slices in pie chart in Tableau?

Hi sindhu, You can manually move the labels ...READ MORE

answered Mar 13 in Tableau by Cherukuri
• 25,700 points
706 views