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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Customized Table Visual

I have these sample tables 

Intake Table
Intake #StateRequest TypeProject Name
LNC-001ActiveOthersProtégé 201
LNC-002CancelledIssueDimesion 56
LNC-003ResolvedProblemMonthly dispatch
LNC-004ActiveReviewBend Joint
LNC-005ActiveProblemClive Bandwidth
LNC-006ActiveReviewBusiness Reengineering
LNC-007CancelledProblemType Cde cleanup
LNC-008ResolvedReviewProtégé 205
LNC-009ActiveProblemProtégé 2024
LNC-010ActiveReviewProtégé 209
    
Property Table
Property #Intake #Property AddressStatus
PL001LNC-004123 Fake streetActive
PL002LNC-005234 Vulture streetResolved
PL003LNC-00467 glossy sw Active
PL004LNC-008123 Fake streetActive
PL005LNC-00890 weint streetActive
    
Reviewing Table
Review IDIntake #Review SubjectStatus
RW001LNC-004Test GroundActive
RW002LNC-005Reflect ProjectActive
RW003LNC-004Ultra freightActive
RW004LNC-008Candles testActive
RW005LNC-008Resting houseActive
RW006LNC-010design GroundActive

 

Closing Table
Closing IDIntake #Closing SubjectStatus
CL001LNC-004TESTINGActive
CL002LNC-005MuseActive
CL003LNC-004BottleActive
CL004LNC-008DrinksActive
CL005LNC-008RestActive
CL006LNC-005YellowActive

 

I want to achieve this. Thank you in advance

Intake #StateRequest TypeProject Name# of Properties# of Reviews# of Closing
LNC-001ActiveOthersProtégé 201000
LNC-002CancelledIssueDimesion 56000
LNC-003ResolvedProblemMonthly dispatch000
LNC-004ActiveReviewBend Joint222
LNC-005ActiveProblemClive Bandwidth112
LNC-006ActiveReviewBusiness Reengineering000
LNC-007CancelledProblemType Cde cleanup000
LNC-008ResolvedReviewProtégé 205222
LNC-009ActiveProblemProtégé 2024000
LNC-010ActiveReviewProtégé 209010
1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

@Anonymous So like the attached PBIX file? (below signature)

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

@Anonymous So like the attached PBIX file? (below signature)

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Thank you. i see what you did. A count 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.