Help on stacked column chart legend data

[Anonymous]

Hi,

i have two tables called "movecount" and time dimenssion table (which is created from sql query) : 

this table data is coming from postgres : 

Country	operator	S_name	arrival_time
Finland	line	Africa||wca1	19-12-2020
Angola	hsbc	Africa||wca1	19-01-2021
africa	bcm	unknown	15-12-2020
asia	mcc	inter regional ||wfa-1	17-12-2020
china	cosc	Asia|| wfa-2	15-010-2021

and i have created one time dimensional table which has all weeks,monthnames,years and i have joined both tables with relation of date.

Note : The above table data is dummy data 

i have provided 3filters which is operator ,country and date range.

In Axis am giving week number,year and month.In legend am giving S_name and in values am calculating count of S_name.

when am plotting this stacked column chart whenever there is a zero call it was eliminating that week itself and in above graph am filtering data by country,operator,date but it is display total S_names of both 1st and 3rd week not according to the filters(means the data is displaying wrongly).

Measure : 

count of S_name = if(isblank(count(S_name)),0) ,count(s_name)

i need to achieve if there is any zero call then it should display zerocall in legend.

Can someone please help me with this.

Thanks in advance

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

According to your sample picture, it seems that the zero calls are displayed in your column chart but their data label disappeared because its color is white, you can try to change the data label color of this column chart to a dark color to make it display:

https://www.c-sharpcorner.com/blogs/data-labels-and-axis-style-formatting-in-power-bi-report

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dkaushik]

Hi @Anonymous ,

You can include the blanks by enabling "Show items with no data". Click on the downward arrow next to your axis field. Seel below:

Also, you can rename the field under "Values" to your desired name instead of auto generated total_S names and upon right clicking on that field you can switch btween multiple options like average, count, sum etc.

Thanks,

Dheeraj

Please mark as solution and give kudos if this helps you.