I've created two clustered bar charts, for male and female age structure.
But I would like something more like this:
Is it possible to make a "mirror reflection" of the blue chart?
Or maby it is possible to place both male and female in one chart.
Yes granted its not as customizable as I would like.
However what you could do is create a Column (for buckets) like this...
Period Slicer COLUMN = SWITCH ( TRUE (), 'Calendar'[Year] >= 2007 && 'Calendar'[Year] <= 2010, "2007 - 2010", 'Calendar'[Year] >= 2011 && 'Calendar'[Year] <= 2013, "2011 - 2013", 'Calendar'[Year] >= 2014, "2014 - Now" )
You'll sacrifice some detail but you'll fit all on one page - depending on how many years you'll have to include per bar!
And use this column (which with the above example will be 3 Years of Data per Bar)
You may have to do 5 or 10 depending on what screen/page size you are working on...
Hope this helps!
Can Anyone please help, Tornado charts is used when both side having same digits numbers, time suppose if I want to Display hourly Temperature v/s NetSale for a day suppose 20180110, here Tornado chart will not work. Please suggest me a chart which display Temperature, Netsale as per Hourly basis.