Forum Discussion

Ben_Bocking4's avatar
Ben_Bocking4
Regular Visitor
2 years ago

Column Chart Fields

I have created a column chart visual which displays how many items are at each operation. Along the X-axis all the operations are listed and then the quantity is listed on the y axis. I have a number...
Need Help
SamWiseOwl's avatar
SamWiseOwl
Super User
2 years ago

Hi Ben_Bocking4 

Click on the X-axis column (RegionName in this image) and choose Show items with no data

 

  • Ben_Bocking4's avatar
    Ben_Bocking4
    Regular Visitor
    2 years ago

    Hi SamWiseOwl. I have 'Show Items with No Data' ticked however that works until I apply any form of slicers to the visual.

    • SamWiseOwl's avatar
      SamWiseOwl
      Super User
      2 years ago

      Hi Ben_Bocking4  have you tried Anonymous suggestion of changing from using cross highlighting to cross filtering?

       

      I'm not 100% sure what the issue is but one way of solving it would be a measure.

      Show values with 0 =
      If( IsBlank( [Your Calculation], 0, [Your calculation])
      So for example:
      Show values with 0 =
      If( IsBlank( Sum(Sales[Quantity])), 0, Sum(Sales[Quantity]))

      This will force the rows to show a 0 and prevent them from hiding.

      • Ben_Bocking4's avatar
        Ben_Bocking4
        Regular Visitor
        2 years ago

        Hi SamWiseOwl. I have tried Anonymous suggestion however that hasnt seem to resolve the problem. The measure also doesn't seem to work with the data and causes some other issues. The problem itself is that when i apply a slicer to the page it filters visuals to only show columns that have data whereas I still want to see the columns that have no data. I have tried your original suggestion of showing items with no data however that only works until a slicer is applied.