How to show 0 values in stacked bar chart

[Anonymous]

Hello, 

I'm tring to display average values in stacked bar chart, some of them have avarge of 0, but unfortunately the chart doesn't display the 0 values. 

I created the following queries to deal with the situation...but it still didn't work. 

1.

avg_calc=
CALCULATE (
AVERAGEX (
Fact_FormAnswerRows,
IFERROR ( VALUE ( Fact_FormAnswerRows[Selected Answers] ), BLANK () )
),
ALL ( dim_customer )
)

2.

check_avg_calc

IF ( [avg_calc] = 0, "0", [avg_calc] )

In the chart i used the check_avg_calc to display the values.

Anyone knows how to deal with it?

Thanks

[hashtag_pete]

Hello KatyaK,

have you tried the following:

it showed me the textual content with Value 0

Best 

Stephan

[Anonymous]

It didn't work  😞

[PoojaDarbhe]

Hi @Anonymous 

Could you please attach the image what do you exactly want?

Best regards,

Pooja Darbhe

[Anonymous]

Hi Pooja Darbhe!

Let's say this is my stacked bar chart (the dashed line is the chart line):

textual content ------------>10
textual content----------->1
textual content ------->0
textual content ----------------------------------->30
textual content ------->0
textual content ------->0
textual content ------->0
textual content ----------------------------------------->60

So i want to display 0 values in the chart as well. 

now i have only:

textual content ---------------------->10
textual content----------->1
textual content ----------------------------------->30
textual content ----------------------------------------->60

[PoojaDarbhe · Accepted solution]

Hi @Anonymous 

I have just pulled the values on the graph and it is working please check below.

Please let me know is it as expected?

Best Regards,

Pooja Darbhe