topic Including a 0 in my stacked bar chart. in DAX Commands and Tips

Including a 0 in my stacked bar chart.

Khansa — Sat, 30 Nov 2024 16:12:31 GMT

Hello Everyone,

I am creating a stacked bar chart for three columns total spend, planned spend, and remaining budent on each project. For instance, one bar must show like 0 remaining, 50k spend, and 50k planned spend out of 100,000 budget allocation. But my chart is not showing in this way for each project. Is there any way I can do this?

This is my data set (small sample)

This is what I want (here no zero value is showing but I want it in my chart)

And this is what I created:

Kindly help me to find a solution.

Thanks.

Re: Including a 0 in my stacked bar chart.

lbendlin — Sat, 30 Nov 2024 17:48:35 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Including a 0 in my stacked bar chart.

Anonymous — Fri, 06 Dec 2024 08:52:10 GMT

Thanks for the reply from lbendlin , please allow me to provide another insight:

Hi, Khansa

Based on your requirements, you can try the following solution:

1.Here is my sample data:

2.Next, add a parameter to the column containing zero values to create a new calculated column:

actual_sopend = 'Table'[actual spend]+5000

remaining_ = 'Table'[remaining]+5000

3.Then, apply these calculated columns to the visualisation object:

4.Next, modify the display value column to the original column:

You may need to note that you need to modify each item individually in the yellow box shown in the image above.

5.Here's my final result, which I hope meets your requirements.

6.Of course, you can also add these to the tooltips to display all values when hovering over with the mouse:

7.Here's my final result.

For more details, please refer to:

Create report tooltip pages in Power BI - Power BI | Microsoft Learn

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

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