Forum Discussion
filter empty values in x axis
Can you drag your value column to the visual filters area and set it to "is not blank"?
Just tried but that did not work.
What about "not 0"?
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?
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.
