filter empty values in x axis

[ea6les82]

Hi Guys,

I have a report that I use to drill through data. When I drill down into data it looks like the values it populates on the x axis do not get filtered. This causes the graph to expand in size with empty values. For example, I have a graph that shows a count of customers by fiscal month and the first data available begins in July but the graph shows a value of 0 begining in Jan.

How can i fix this issue? I also see this when I try to drill through the hierarchy and see employees who do no have any customers because they do not report through whichever manager you decide to drill into. I have a top down drill down for hierarchy.

[Greg_Deckler]

Can you drag your value column to the visual filters area and set it to "is not blank"?

[ea6les82]

Just tried but that did not work.

[Greg_Deckler]

Has to be something wonky with whatever measure you are using. I created a very simple table:

Year	Month	Count
2014	July	5
2014	August	7
2014	September	8
2014	October	15
2014	November	22
2014	December	23
2015	January	25
2015	February	30
2015	March	33
2015	April	35
2015	May	40
2015	June	44
2015	July	48
2015	August	52
2015	September	53
2015	October	55
2015	November	56
2015	December	60

I created a column graph that had Year and Month in the axis and Count in the value. Drilling into Year only gave me back months in 2014. I then created a measure called "Measure" which was simply "Measure = COUNT(Customers[Count])" and that worked just fine as well.

Would need more information about your data, model, etc. Sample data is always helpful.

[Greg_Deckler]

What about "not 0"?

[greggyb]

Visualizations will plot every label for which your measures return a non-blank value. 0 counts as non-blank. Empty string counts as non-blank.

For you to be seeing everything displayed, your measures must be returning non-blanks for every label you choose. What measures are you using in these visualizations?