Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
chesterish
Frequent Visitor

Matrix type visual (unsure how to describe it)

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

 ABCD
A100908070
B90504010
C80403015
D70101520
2 REPLIES 2
chesterish
Frequent Visitor

@amitchandak 

Please see the attached spreadsheet exported from PowerBi.

Thanks 🙂

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

 

amitchandak
Super User
Super User

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!