How to get stacked bar chart to show 0 for months with no data without messing up filter

[Earl40]

Hello,

I have a stacked bar chart where there is no data for certain months. I am trying to figure out a  way to show the month with no data as 0 instead of just missing from the chart, without impacting my filter. If I do "show items with no data" it negates my date filter. Im looking to show data from 5/1/2024 - 12/31/24.  Thank you in advance

IDDate ProcessedRequest Type

ID	Date Processed	Request Type
1	Tuesday, January 2, 2024	A
2	Wednesday, January 3, 2024	B
3	Wednesday, February 7, 2024	B
4	Friday, February 16, 2024	A
5	Monday, February 19, 2024	A
6	Sunday, March 3, 2024	A
7	Thursday, March 21, 2024	B
8	Thursday, April 4, 2024	A
9	Saturday, July 13, 2024	B
10	Thursday, July 18, 2024	A
11	Friday, August 9, 2024	B
12	Monday, August 12, 2024	A
13	Friday, October 11, 2024	A
14	Thursday, October 31, 2024	A
15	Wednesday, December 4, 2024	B
16	Thursday, December 5, 2024	B

[Ritaf1983 · Accepted solution]

Hi @Earl40 
If you have a calendar table connected to the transactions table, the "Show items with no data" option should work while respecting the filters.

I attached PBIX so you can follow

More information about how and why you need a calendar table in your data model is here :

https://radacad.com/do-you-need-a-date-dimension

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

[bchager · Accepted solution]

@Earl40 One way you might be able to solve this problem is by creating a measure like below. Use that instead of applying count to the ID column.

Show_Zero =

VAR _count = COUNT ( 'Table'[ID] )

RETURN IF ( ISBLANK ( _count ), 0, _count )

[Ritaf1983 · Accepted solution]

Hi @Earl40 
If you have a calendar table connected to the transactions table, the "Show items with no data" option should work while respecting the filters.

I attached PBIX so you can follow

More information about how and why you need a calendar table in your data model is here :

https://radacad.com/do-you-need-a-date-dimension

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

[Earl40]

@Ritaf1983 thank you so much. Is it possible to show the month name instead for the number (January instead of 1)?