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

Create custom filtered table

Hello, I have a table with tree columns 

nodescact
1558957SA129656
1558957SA122396
1560476SA16789
1559200SA161206
1559691SA253429
1558958SA256887
1558958SA250926
1558958SA250778
1559694SA359725
1559692SA357488
1560573SA38300
1551588SA359723
1551588SA456904
1545140SA457487
1545140SA453428
1544804SA451724
1544804T161202
1545086T17805
1537829T150733
1537824T19909
1537933T256978
1537933T212029
1537933T28260
1534214T250712
1534214T350732
1534205T37818
1534205T350914
1530771T38846
1530771T451575
1532969T450736
1532970T459721
1532970T461199

and i would like to expand it based on data filtering to table with nine columns like below. 

NoSA1SA2SA3SA4T1T2T3T4
1530771      884651575
1532969       50736
1532970       120920
1534205      58732 
1534214     5071250732 
1537824    9909   
1537829    50733   
1537933     77267  
1544804   5172461202   
1545086    7805   
1545140   110915    
1551588  5972356904    
155895752052       
1558958 158591      
155920061206       
1559691 53429      
1559692  57488     
1559694  59725     
15604766789       
1560573  8300     

 

1 REPLY 1
amitchandak
Super User
Super User

@Wirestat , Create a matrix visual and use desc in column.

 

If you need a calculated(data) table. Pivot in power query -

Pivot Data(Power Query) :https://www.youtube.com/watch?v=oKByyI09Bno&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=12

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