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
sandy_a
Frequent Visitor

Tabular turn row records into category columns grouped by date

I'm fairly new to Tabular, DAX and Power BI although I have a history with SSAS and SSRS.  

 

I was hoping someone could point me in the right direction of how to achieve the following with a Linked Tabular model (i.e. I can't apply the groupings in the Power BI report)

 

I have a data table in the following record format:

sandy_a_0-1621037389292.png

 

Which I'm trying to display in Power BI in the following group format:

sandy_a_1-1621037428403.png

 

This is where I've been able to get to by creating a 'Total' measure with DAX Calculate(Sum(Table[Amount]), Filter(Table, Table[Type] = "A")). 

sandy_a_2-1621037623677.png

 

 

Do I need to create Measures or a Calculated Group in my Tabular model (or something else)?  

 

Thanks in advance for any help you can give me.

 

 

1 ACCEPTED SOLUTION
sandy_a
Frequent Visitor

Solved - just needed to use a Matrix visual in Power BI

View solution in original post

1 REPLY 1
sandy_a
Frequent Visitor

Solved - just needed to use a Matrix visual in Power BI

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.

Top Solution Authors