Matrix type visual (unsure how to describe it)

[chesterish]

Hi

In have 4 columns, eg:

A

B

C

D

Each column represents a system that has rooms in it and I want to create a visual that can show, for example, 100 rooms are in system A, and 90 of those are in system B, 80 in system C, and 70 in system D

So my visual would look something like this:

Can anyone help?

Thanks in advance

	A	B	C	D
A	100	90	80	70
B	90	50	40	10
C	80	40	30	15
D	70	10	15	20

[chesterish]

@amitchandak 

Please see the attached spreadsheet exported from PowerBi.

Thanks 🙂

https://drive.google.com/file/d/1ZZqdf6m2xaaXKANo-mMfg_p1cCFEsQVP/view?usp=drive_link

[amitchandak]

@chesterish , This is a case of cohort analysis, but for that, we need two two columns that will have these values A,B, C, and D

Please share the source data sample

Example in case of Date

Power BI Cohort Analysis, Customer Retention %- https://youtu.be/qY1SDF1cwsg