Forum Discussion

kalyani's avatar
kalyani
Icon for Helper I rankHelper I
8 years ago

Graph show 0 values with Axis details

Hello,

 

I have the source data in excel. My visuals are based on the month and continent levels.

 

I'm using Barchart to show the numbers, Continents will be in X Axis and Month will be in Y Axis. If I select MArch month, there is no data entered, so the entire space of the chart is showing empty(seems like there is no graph in the place). Is there a possibility to show the X and Y axis of the graph, evem if there is no value for the specific selections.

 

Similar to the bar grpah, I'm using Donut chart and Tornado also to show some 2 different attribute values for the Continents. In the all the charts it is showing empty if there are no values for the selections(say March)

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hey kalyani

     

    Try to right click on your field and select "Show items with no data." Let me know if that helps.

     

    Thanks,

    Parker

    • kalyani's avatar
      kalyani
      Icon for Helper I rankHelper I
      8 years ago

      Hi, sorry I should have mentioned about this. Show items with no data will work only if I have all the continents and month entered with 0 value in source. What if a user did not enter anything for the continent for March as it has no value. Like I dont even have an entry in source file, but want to display all the continents in axis of graph if everything is null

      • v-yuta-msft's avatar
        v-yuta-msft
        Icon for Community Support rankCommunity Support
        8 years ago

        Hi kalyani,

         

        You can replace null with 0 in Query Editor. Click Query Editor-> Replace Value.

         

         

        Regards,

        Jimmy Tao