Need creative help - 2 dimensions x 2 facts

I presented at a recent PASS Marathon about how Excel users can get started with Power BI.  I wrote a follow up blog post earlier this week where you can access the video of the session and also take a look at the workbook.

http://exceleratorbi.com.au/moving-excel-power-bipass-presentation

I am not saying this is the world class visualisation, but it may help you get going.  I suggest something like I have demo'd here, but I would add a second measure to the bar chart (top left) with TY and LY as 2 separate bars in the values section.  You will need some DAX to do this, but it will be worth it.

Also take a look at this thread - I provide some info on writing the DAX measure to do this

http://community.powerbi.com/t5/Desktop/Comparing-this-year-and-last-year-measure-on-a-bar-chart/m-p/16877#U16877

I hope that helps