Bypassing or overriding the Year/Qtr/Month date drill down effect (Stacked Bar Graph).

[BarryB]

Hi.

I'm wanting to simplfy the Stacked Bar Graph so it just shows the month, without the need to use the inbuilt Year/Qtr/Month drill down of the stacked bar graph.

( NOTE: if the X-axis said "...Nov17 | Dec17 | Jan18 | Feb18..." then that would be fab)

The stacked bar graph is doing what I want as far as the monthly columns, but a yearly range is too restrictive for what I need.

Why? The underlying data is multi-year (about 15 months so far) to look at trends from a landmark date. There is no value comparing April 2017 to April 2018, but there is value in comparing November 2017 to February 2018.

I'm assuming there is somthing simple to do this, I just haven't found it.

Thanks in anticipation.
Cheers
Barry

Sample of data:

host_month_year | Host_Type | Count_months
=================================
1/11/2017 MedTech 3
1/11/2017 Development 7
1/11/2017 ZedMed 23
1/11/2017 Consumer Portal 32
1/11/2017 Communicare 35
1/11/2017 AIO-GM 35
1/11/2017 Medical Director 114
1/11/2017 Best Practice 265
1/12/2017 Development 1
1/12/2017 Communicare 20
1/12/2017 ZedMed 24
1/12/2017 Consumer Portal 49
1/12/2017 AIO-GM 55
1/12/2017 Medical Director 90
1/12/2017 Best Practice 199
1/01/2018 Development 3
1/01/2018 Communicare 57
1/01/2018 Consumer Portal 66
1/01/2018 ZedMed 70
1/01/2018 AIO-GM 87
1/01/2018 Medical Director 191
1/01/2018 Best Practice 280
1/02/2018 Development 13
1/02/2018 Communicare 36
1/02/2018 ZedMed 43
1/02/2018 Consumer Portal 52
1/02/2018 AIO-GM 113
1/02/2018 Medical Director 252
1/02/2018 Best Practice 370

[v-jiascu-msft · Accepted solution]

Hi @BarryB,

Approach 1:

Use the date hierarchy and delete the Year, Quarter parts.

Approach 2:

Add a new column.

Month = FORMAT([Date], "MMMM")

YearMonth = FORMAT([Date], "MMMYYYY" )

Best Regards,

Dale

[BarryB]

That's cool!

I chose the second Approach, but I can see how the first would work.

Much appreciated.