Forum Discussion

McKenzieK's avatar
McKenzieK
New Member
10 years ago
Solved

Help with Measures in Clustered Column Chart

Hi Power BI Community, 

 

I'm a new Power BI Desktop user and I'm having some difficulty with the clustered column chart that I've created using measures.  So far I've created individual measures to count the blanks within the seperate fields in my data (using the COUNTBLANK formula), but not all of the data I want to see is displaying.  

 

There are a total of 8 fields whose blanks I need to count; however, only 5 of those actually contain blanks/null values.  Those 5 fields show up along the X-axis in the form of a column, but those with no blanks don't show up on the chart at all, not even a zero on the X-axis (they are, however, displayed in the legend). The issue that I'm running into is that I need at least a zero to show up on the X-axis to display that there are three other fields that contain no zeroes at all, and that they haven't been omitted from the chart.  Is there a good way to do this?

 

Also, why is it that when you create a cluster column chart with measures, X-axis does not show up under Format?  If possible, I'd like to create an X-axis title for this chart. 

 

 

Thanks in advance!

Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    Hi McKenzieK,

    That absense seems a behavior by design, to at least show up a 0, you could follow the picture below.

    create a measure like SWITCH(ISBLANK(COUNTBLANK(Tname[COLname])),TRUE(),0,COUNTBLANK(Tname[COLname]))

    In the "format" of clustered column, enable the "data labels"

3 Replies

  • austinsense's avatar
    austinsense
    Icon for Impactful Individual rankImpactful Individual
    10 years ago

    In the axis field, click the drop-down menu and select "show items with no data"

    • McKenzieK's avatar
      McKenzieK
      New Member
      10 years ago

      Unfortunately it doesn't look like I have that option--the fields are only displaying under 'Value' and I'm unable to move them to Axis.  When I right-click on the fields, the only choice I'm given is to 'Remove Field'. Am I missing something?

      • Eric_Zhang's avatar
        Eric_Zhang
        Icon for Microsoft Employee rankMicrosoft Employee
        10 years ago

        Hi McKenzieK,

        That absense seems a behavior by design, to at least show up a 0, you could follow the picture below.

        create a measure like SWITCH(ISBLANK(COUNTBLANK(Tname[COLname])),TRUE(),0,COUNTBLANK(Tname[COLname]))

        In the "format" of clustered column, enable the "data labels"