-
1. Re: Display 12 months in bar graph when no data is availablen
suman kumar Aug 31, 2018 3:57 AM (in response to manojkumar.p.0)Hi Manoj,
It is possible to show January to December when value is zero or null but you should have date in your data.
In your Data, You have only two date. And May is showing just because of it's in between of April and June.
Please mark correct and helpful if you get this.
Best-
Suman
-
2. Re: Display 12 months in bar graph when no data is availablen
manojkumar.p.0 Sep 2, 2018 7:41 PM (in response to suman kumar)There are lot of posts which says it is possible to display 12 months in X-axis (even if there is no data). I tried various ways but could not get the desired result
-
3. Re: Display 12 months in bar graph when no data is availablen
Nitin Paighowal Sep 2, 2018 7:55 PM (in response to manojkumar.p.0)Hello Manoj
I created another sheet with just "Month" information from Jan to Dec.
I used this sheet to right joined with your data
And finally I showed this data on graph
PLEASE MARK IT AS CORRECT ANSWER IF SOLVES YOUR QUERY
-
DateTime_v10.2.twbx 21.3 KB
-
-
4. Re: Display 12 months in bar graph when no data is availablen
Shinichiro MurakamiSep 2, 2018 7:55 PM (in response to manojkumar.p.0)
Here is one idea.
Show missing value is only effective between min and max of existing.
Then,
Change x-axis date to continuous month.
20 is appropriate to keep 10 days gap between month.
Thanks,
Shin
-
DateTime_SM_10.1.twbx 13.4 KB
-
-
5. Re: Display 12 months in bar graph when no data is availablen
manojkumar.p.0 Sep 2, 2018 9:33 PM (in response to Shinichiro Murakami)Hi,
Thanks, it worked perfectly. Two changes required
1. Only half of the first bar (the bar for April) is getting displayed
2. Need to include Year in X-axis
-
6. Re: Display 12 months in bar graph when no data is availablen
Shinichiro MurakamiSep 2, 2018 9:37 PM (in response to manojkumar.p.0)
HI Manoj,
Sorry, I am not sure about your expectation/question.
Please attach illustrations to explain the issue, expectations.
Thanks,
Shin
-
7. Re: Display 12 months in bar graph when no data is availablen
manojkumar.p.0 Sep 2, 2018 9:39 PM (in response to Shinichiro Murakami)Hi,
Thanks, it worked perfectly. Two changes required
1. Only half of the first bar (the bar for April) is getting displayed. You could see this by starting your Fiscal year from April
2. Need to include Year in X-axis
-
8. Re: Display 12 months in bar graph when no data is availablen
Shinichiro MurakamiSep 2, 2018 9:41 PM (in response to manojkumar.p.0)
2. Need to include Year in X-axis
How? please add illustrations.
Shin
-
9. Re: Display 12 months in bar graph when no data is availablen
manojkumar.p.0 Sep 2, 2018 9:52 PM (in response to Shinichiro Murakami)X-Axis to have both month and year.. April 2018 to March 2019
-
10. Re: Display 12 months in bar graph when no data is availablen
Shinichiro MurakamiSep 2, 2018 10:21 PM (in response to manojkumar.p.0)
Hope this helps.
If series of posts helped, please mark my answer as correct / helped to close the thread, not from inbox but from original post.
Thanks,
Shin
-
DateTime_SM_10.1_v2.twbx 14.9 KB
-
-
11. Re: Display 12 months in bar graph when no data is availablen
manojkumar.p.0 Sep 2, 2018 11:06 PM (in response to Shinichiro Murakami)Thanks Shin!!!
One question... How did you change the Range
Edit Axis > General > Range--> Fixed
it is 0 to 12, how do I change this to date format, as in your screenshot above
-
12. Re: Display 12 months in bar graph when no data is availablen
manojkumar.p.0 Sep 2, 2018 11:11 PM (in response to manojkumar.p.0)Got it by changing the Format of the date field.
Thanks Shin!!!
-
14. Re: Display 12 months in bar graph when no data is availablen
amar savale Sep 3, 2018 12:27 AM (in response to manojkumar.p.0)