What you describe are the measure names being shown as line items and a month date dimension as columns. What you'd like to do is to calculate the % change for each measure.
Copy the sheet, then change all the measures to a quick table calculation using the Year over Year Growth (don't be fooled by the name, it is just column over column calculation and will look to the two columns that you have identified for calculating the growth %). Hide the first date on the second sheet so the column doesn't show. Then move the two sheets side by side within a dashboard so that the rows line up. Be sure that any filters apply to both sheets. Your result should look something like this (which can be cleaned up further):
Thanks Brad, I folllowed the above steps, is there way to get rid of the title in the % change column (in your example last column title 'June') and how to get rid of line measure names shown as line items next to the % change on the new sheet, so that i can line up 2 sheets in a dashboard?
Thanks for your help
As you likely noticed, the dashboard above does have the rows aligned. But your next question is to get rid of the titles in sheet 2 while still maintaining alignment with the rows in Sheet1. I then used an empty parameter with the same value as filler after choosing not to show the header for the duplicate date field.