Matrix

[IF]

Hi,

I have a bad data source.  The data example is Table:AC

Country	City	TownType	Month	V1	V2
Country1	City1	A	05.2020	0.001	85.3
Country1	City1	B	05.2020	0.002	85.3
Country1	City1	C	05.2020	0.002	85.3
Country1	City2	A	05.2020	0.002	83.3
Country1	City2	B	05.2020	0.002	83.3
Country1	City2	C	05.2020	0.003	83.3
Country1	#	A	05.2020	0.009	78.6
Country1	#	B	05.2020	0.008	78.6
Country1	#	C	05.2020	0.007	78.6
Country2	City3	A	05.2020	0.004	85.9
Country2	City3	B	05.2020	0.003	85.9
Country2	City3	C	05.2020	0.002	85.9
Country2	City4	A	05.2020	0.021	54.5
Country2	City4	B	05.2020	0.024	54.5
Country2	City4	C	05.2020	0.071	54.5
Country2	#	A	05.2020	0.041	67.8
Country2	#	B	05.2020	0.001	67.8
Country2	#	C	05.2020	0.007	67.8
#	#	A	05.2020	0.041	67.1
#	#	B	05.2020	0.001	67.1
#	#	C	05.2020	0.007	67.1

I have also table: PL

CountryCityTownTypeMonthV3

Country1	City1	A	05.2020	0.002
Country1	City1	B	05.2020	0.002
Country1	City2	A	05.2020	0.004
Country1	City2	B	05.2020	0.002
Country1	#	A	05.2020	0.002
Country1	#	B	05.2020	0.008
Country2	City3	A	05.2020	0.004
Country2	City3	B	05.2020	0.008
Country2	City4	A	05.2020	0.021
Country2	City4	B	05.2020	0.029
Country2	#	A	05.2020	0.041
Country2	#	B	05.2020	0.011
#	#	A	05.2020	0.048
#	#	B	05.2020	0.001

I have also city and month tables that I connect the tables and use the columns from city and month table in the page.

I want to make a matrix and show total of A and B values at the column V1, V2 value and V3 value.

The file is available at the dropbox, which can be much easier to work on it: https://www.dropbox.com/s/5awowcof9xanuow/Q%20Table%20and%20Graph.pbix?dl=0

Thanks in advance!

[amitchandak · Accepted solution]

@IF , If I got it correctly.  If V1_602, V2_602,  V3_602 are measures.

Then you can use "Show on row" and put a month on the column and can get this

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

[IF]

Yes, they are measures and works as you refered. Thanks a lot 🙂