Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hello, I have a table with tree columns
no | desc | act |
1558957 | SA1 | 29656 |
1558957 | SA1 | 22396 |
1560476 | SA1 | 6789 |
1559200 | SA1 | 61206 |
1559691 | SA2 | 53429 |
1558958 | SA2 | 56887 |
1558958 | SA2 | 50926 |
1558958 | SA2 | 50778 |
1559694 | SA3 | 59725 |
1559692 | SA3 | 57488 |
1560573 | SA3 | 8300 |
1551588 | SA3 | 59723 |
1551588 | SA4 | 56904 |
1545140 | SA4 | 57487 |
1545140 | SA4 | 53428 |
1544804 | SA4 | 51724 |
1544804 | T1 | 61202 |
1545086 | T1 | 7805 |
1537829 | T1 | 50733 |
1537824 | T1 | 9909 |
1537933 | T2 | 56978 |
1537933 | T2 | 12029 |
1537933 | T2 | 8260 |
1534214 | T2 | 50712 |
1534214 | T3 | 50732 |
1534205 | T3 | 7818 |
1534205 | T3 | 50914 |
1530771 | T3 | 8846 |
1530771 | T4 | 51575 |
1532969 | T4 | 50736 |
1532970 | T4 | 59721 |
1532970 | T4 | 61199 |
and i would like to expand it based on data filtering to table with nine columns like below.
No | SA1 | SA2 | SA3 | SA4 | T1 | T2 | T3 | T4 |
1530771 | 8846 | 51575 | ||||||
1532969 | 50736 | |||||||
1532970 | 120920 | |||||||
1534205 | 58732 | |||||||
1534214 | 50712 | 50732 | ||||||
1537824 | 9909 | |||||||
1537829 | 50733 | |||||||
1537933 | 77267 | |||||||
1544804 | 51724 | 61202 | ||||||
1545086 | 7805 | |||||||
1545140 | 110915 | |||||||
1551588 | 59723 | 56904 | ||||||
1558957 | 52052 | |||||||
1558958 | 158591 | |||||||
1559200 | 61206 | |||||||
1559691 | 53429 | |||||||
1559692 | 57488 | |||||||
1559694 | 59725 | |||||||
1560476 | 6789 | |||||||
1560573 | 8300 |
@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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.