topic Re: Show zero values in bar chart in Developer

Show zero values in bar chart

Kavya123 — Fri, 29 Oct 2021 06:51:01 GMT

Hi All,

I want to show zero values in bar chart. Please find the sample data and the screenshot.

Answer text field is dimension and sector field is filter in the report..

Below is the measure I am using in Bar chart :

New Measure =

var v1=

CALCULATE(DISTINCTCOUNT( AnswerHistory_Benchmarking[POrganization]) , FILTER(AnswerHistory_Benchmarking, AnswerHistory_Benchmarking[POrganization] <> 6377) ))

return

if(ISBLANK(v1),0,v1).

If I select Asset and wealth Management in sector filter then all the answet texts should display in the y axis.
For ex: Answer text DDD doesn't contain Asset and wealth Management still it should display in Y axis and represent as zero.

Below screenshot is my expected output.

Thanks in advance

Re: Show zero values in bar chart

lbendlin — Sat, 30 Oct 2021 23:28:26 GMT

Usually you can achieve that by using fields from the dimension table and selecting "show items with no data"

Please show a sanitized version of your data model.

Re: Show zero values in bar chart

V-lianl-msft — Wed, 03 Nov 2021 06:43:43 GMT

Hi @Kavya123 ,

Create a sector table, then create a relationship with the fact table and use it as axis.

Table 2 = DISTINCT('Table'[Sector])

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

Re: Show zero values in bar chart

AllardBon — Thu, 14 Dec 2023 13:55:41 GMT

Hi Kavia,

There is a simpeler solution to your problem.

When you create a measure for the number of students, for instance:

NumberOfStudents = COUNT(SP_DASHBOARD[STUDENTNUMBER])

, the 0-values are not shown in the charts.

When you create the measure like this:

NumberOfStudents = IF(COUNT(SP_DASHBOARD[STUDENTNUMBER])=0, 0, COUNT(SP_DASHBOARD[STUDENTNUMBER]))

, the 0-values are shown in the charts.

Re: Show zero values in bar chart

lbendlin — Fri, 15 Dec 2023 01:47:09 GMT

@AllardBon I would consider that to be a bug - as it means that BLANK() is treated as being equal to 0 which is incorrect.

Re: Show zero values in bar chart

kkanukurthi — Mon, 21 Oct 2024 06:49:24 GMT

Hi @V-lianl-msft ,

Im looking for similar kind of requirement above. Tha bar chart should display "0" even if we dont have blank values in fields instead of fields missing when filter. I am aware of "show items with no data". This is something which i can see categories on y-axis with not displaying "0". Im looking for categories should display "0" when we filter on other columns.

Expected Output:

Thanks in advance,

Re: Show zero values in bar chart

lbendlin — Mon, 21 Oct 2024 10:50:50 GMT

That's a bad UX. Have your users asked for that?

Re: Show zero values in bar chart

kkanukurthi — Mon, 21 Oct 2024 12:20:20 GMT

Yes @lbendlin since i hide x-axis values and enable data labels users want to see '0' display for categories which have no data on bar chart.

Another request please, can we lock slicer drop down list on top screen instead of using scroll bars down the way to check category. It is occupying more space overlapping with other visuals.

Thanks in advance