Stacked column visual does not show months that have no data

Tcurtis

Board Regular
Joined
Aug 15, 2009
Messages
147
I have a chart that is created by summing quantities during a given month. Issue is that some months have no activity. How can my visual show all months that are null or 0? I have tried show all with no data selection in Powerbi but that shows all of the months in my dataset. I need to have my chart filtered down to the year selected by the individual.
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

mrshl9898

Well-known Member
Joined
Feb 6, 2012
Messages
1,951
You'll need another dataset with all the months, then create a relationship to that or use LOOKUPVALUE to get the data you need against the months.
 

Tcurtis

Board Regular
Joined
Aug 15, 2009
Messages
147
Not sure if I am doing this right or not. I have my dataset related to my Date table but I still do not get the months without any activity. I am summing a quantity and not counting. Could that make a difference?
 

Tcurtis

Board Regular
Joined
Aug 15, 2009
Messages
147
Here is my most recent measure:
Lost_Cores = IF(ISBLANK(SUM(tbl_MB51[Quantity])),0,
SUM(tbl_MB51[Quantity]))

When I force the 0 into the measure for a null value my date slicer quits working and I get all of the dates going back to the beginning of my dataset (1/1/2010). My date slicer
works will all my other measure and works with this one until I force the 0. I am at a loss as to why.
 

Forum statistics

Threads
1,141,129
Messages
5,704,450
Members
421,350
Latest member
jake9951

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top