Creating Matrix displaying values and percent change

[PerDiem]

I have a table created that looks like the below 

I want to use this to create a matrix displaying the currency as the columns and using the values in Each of the T-1, t-2, and delta as the rows but I cannot get this to work. Below is an example in Excel of how I would like this to look.

Please see below for example data;

Currency	T-1	T-2	Delta
AUD	0.67055	0.67885	-0.01238
CAD	0.7481	0.7494	-0.00174
CHF	1.1182	1.1263	-0.00724
EUR	1.09955	1.1047	-0.00468
GBP	1.2416	1.25215	-0.0085
JPY	0.007474	0.007534	-0.00803
SGD	0.7511	0.7567	-0.00746

And here for an example of my ideal finished product in the form of a table;

	AUD	CAD	CHF	EUR	GBP	JPY	SGD
T-1	0.671	0.748	1.118	1.100	1.242	0.007	0.751
T-2	0.679	0.749	1.126	1.105	1.252	0.008	0.757
Delta	-1.24%	-0.17%	-0.72%	-0.47%	-0.85%	-0.80%	-0.75%

[J-B_]

Bonsoir,

Je vois deux solutions à votre problème : soit agir en amont dans Power Query en dépivotant les colonnes ou soit directement dans Power BI au niveau du visuel « tableau », aller dans « valeurs » puis « options » et activer « changer les valeurs dans les groupes de lignes plutôt que dans les colonnes ».

[PerDiem]

Good Morning J-B, 

The Pivoting/un-pivoting was my first thought as well, but the formatting was always off based on the sample data. I can step back the data and put it into a format that will pivot nicely, but that is before the Delta column was calculated and so the data is incomplete in a way;

Custom	AUD	BRL	CAD	CHF	EUR	GBP	JPY	MXN	SGD
T-1	0.67055	0.2029	0.7481	1.1182	1.09955	1.2416	0.007474	0.05547	0.7511
T-2	0.67885	0.2037	0.7494	1.1263	1.1047	1.25215	0.007534	0.05551	0.7567

After adding it to a table or matrix in power bi, is there a way to change the total row to show a % change between the rows as opposed to a simple total?

Thanks.

[lbendlin · Accepted solution]

There is a new feature that may interest you Measures in Power BI Desktop - Power BI | Microsoft Learn

see attached

[PerDiem]

Hi, a quick follow up. When trying to reformate dynamically so only the total row is a percentage, I cannot select Dynamic in the format dropdown. How do I access that option so I can copy your formatting, as that is the ideal solution? 

[lbendlin]

you need to enable that in the preview feature section of the settings.

[PerDiem]

It would seem that that feature would interest me. Thank you!

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[PerDiem]

lbendlin, please let me know if the edited post is satisfactory.