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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Jdokken
Helper III
Helper III

Table and Matrix combo look in one visual?

Hi- 

I need to replicate the following visual in Power BI but I'm not sure if it's possible. The first 6 columns are formatted like a table and next to the list of projects (changes monthly) we want the last 6 months of trends for cash position/MECP/Difference, which is in a matrix format. The "as of Jun-21" above Contract Value/GMF/ATD, could be a text box . I'm not sure if the paginated report builder could handle this either. 

 

Jdokken_0-1626786851866.png

 

 

 

3 REPLIES 3
v-yiruan-msft
Community Support
Community Support

Hi @Jdokken ,

Base on my research, I'm afraid that there is no custom visual can achieve your requirement. Please review the answer in the following link and check whether it can give you any clue and insight. In addition, you can raise a new idea and add your comments there to make this feature coming sooner.

Custom aggregate column in power bi matrix

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jdokken
Helper III
Helper III

Thanks. I looked at it quickly. It looks promising but I'm connected to a cube and can't create columns so I may be limited as to what I can all customize. 

PaulDBrown
Community Champion
Community Champion

@Jdokken 

 

I think this blog entry will help towards creating the structure you are looking for:

 

Creating a custom or hybrid matrix in PowerBI 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.