Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi @Dhanashree30
In theory yes but it would require much of the work to be done in measures:
I've attached the file to show how I would start it.
If you are happy with this answer please mark as a solution for others to find !
Kudos are always appreciated! Check out our free Power BI video courses.
It is not possible to replicate the exact same functionality as Excel in this case. However, you can achieve a similar result using a matrix visualization by creating two additional tables. Please note that this approach may or may not display the correct table associated with each row, depending on how the data is structured.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.
User | Count |
---|---|
8 | |
2 | |
2 | |
1 | |
1 |