Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Datanauts,
I have created a matrix which is posted below...I am trying to transpose it to look like this template. these are calculated measures. So they do not show up in the query editior data view, and if I unpivot the other columns, these measures break.
How do I transpose this visual?
Hi @Anonymous ,
I am not quite sure whether the row fields in the matrix are hierarchical in your template. If it is, it may be difficult to implement your results. If not, you can try to convert the row and column fields in the matrix for swapping.
If it doesn't meet your requirement, kindly share your sample data if you don't have any Confidential Information.
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-joesh-msft ,
It is a funnel so yes it is hierarchial. PFA the sample data. Looking forward to hearing from you. Thank you!
org_id | org_name | geo_code | country | market_segment | contract_start_quarter | Provisioned | Sum of assigned_seats | QAD | Sum of downloaders | downloads | Assigned 1+ | Assigned > 10% | Assigned > 50% | Consuming (1+) | Consuming (10+) |
D874CD9D542D992A0A4C98 | Brainlounge | JPN | JP | COMMERCIAL | 2017-Q4 | 58 | 11 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 |
ECBAE18C55352B350A4C98A6 | JumpXS | EMEA | GB | COMMERCIAL | 2018-Q1 | 315 | 34 | 13 | 17 | 210 | 1 | 1 | 0 | 1 | 1 |
6BAE37875C936C6C0A495FBD | Babbleset | AMER | US | COMMERCIAL | 2019-Q2 | 12 | 1 | 0 | 1 | 2 | 1 | 0 | 0 | 1 | 0 |
5AFA5F3E57057E367F000101 | Innotype | ASIA | IN | COMMERCIAL | 2019-Q2 | 179 | 173 | 11 | 59 | 14 | 1 | 1 | 1 | 1 | 1 |
D029B4A35717B9957F000101 | Zoomcast | AMER | US | COMMERCIAL | 2019-Q2 | 1054 | 1163 | 61 | 65 | 189 | 1 | 1 | 1 | 1 | 1 |
741524D15CBF274B0A495C93 | Riffwire | AMER | BR | COMMERCIAL | 2019-Q2 | 42 | 42 | 2 | 7 | 6 | 1 | 1 | 1 | 1 | 0 |
5211508055C89B1F7F000101 | Feedspan | AMER | US | COMMERCIAL | 2019-Q2 | 326 | 344 | 30 | 44 | 50 | 1 | 1 | 1 | 1 | 1 |
8EF1373B5CC1EE9F0A495FB9 | Mydo | EMEA | NO | COMMERCIAL | 2019-Q2 | 50 | 71 | 2 | 3 | 1 | 1 | 1 | 1 | 1 | 0 |
518A4C4E572252707F000101 | Tanoodle | ASIA | AU | COMMERCIAL | 2019-Q2 | 75 | 117 | 22 | 27 | 283 | 1 | 1 | 1 | 1 | 1 |
98B51C8B532961AB0A490D4D | Brainlounge | AMER | US | COMMERCIAL | 2019-Q2 | 338 | 337 | 25 | 52 | 535 | 1 | 1 | 1 | 1 | 1 |
6FDF58DD55C1322D7F000101 | Zava | AMER | US | COMMERCIAL | 2019-Q2 | 266 | 263 | 21 | 28 | 40 | 1 | 1 | 1 | 1 | 1 |
F859C4A65717BC3B7F000101 | Quimm | EMEA | IT | COMMERCIAL | 2019-Q2 | 113 | 119 | 24 | 36 | 3996 | 1 | 1 | 1 | 1 | 1 |
4E6040D7544924950A4C98A2 | Babbleblab | EMEA | SE | COMMERCIAL | 2019-Q2 | 320 | 360 | 7 | 7 | 26 | 1 | 1 | 1 | 1 | 1 |
9F55515C56B50A707F000101 | Photobug | AMER | US | COMMERCIAL | 2019-Q2 | 167 | 189 | 15 | 28 | 91 | 1 | 1 | 1 | 1 | 1 |
6716FFD3544984240A4C98A5 | Babbleblab | EMEA | FR | COMMERCIAL | 2019-Q2 | 1318 | 122 | 5 | 15 | 32 | 1 | 0 | 0 | 1 | 1 |
E97C63305747438F7F000101 | Skipstorm | AMER | US | COMMERCIAL | 2019-Q2 | 126 | 126 | 6 | 15 | 4 | 1 | 1 | 1 | 1 | 0 |
B3902DB45388D9620A490D4C | Jabbercube | AMER | US | COMMERCIAL | 2019-Q2 | 353 | 397 | 44 | 70 | 773 | 1 | 1 | 1 | 1 | 1 |
4CE5F16A5748AD3A7F000101 | Realfire | AMER | US | COMMERCIAL | 2019-Q2 | 335 | 278 | 24 | 35 | 327 | 1 | 1 | 1 | 1 | 1 |
D57A2420546E39840A4C98A2 | Zoozzy | AMER | US | COMMERCIAL | 2019-Q2 | 302 | 239 | 32 | 45 | 1360 | 1 | 1 | 1 | 1 | 1 |
5A67E38C5474FAAE0A4C98A7 | Yakitri | AMER | US | COMMERCIAL | 2019-Q2 | 350 | 294 | 30 | 58 | 3171 | 1 | 1 | 1 | 1 | 1 |
9718FFD3545D05690A4C98A5 | Tagcat | EMEA | AT | COMMERCIAL | 2019-Q2 | 66 | 65 | 1 | 2 | 3 | 1 | 1 | 1 | 1 | 0 |
9BB626F8545D1AFA0A4C98A4 | Kaymbo | EMEA | DE | COMMERCIAL | 2019-Q2 | 157 | 172 | 6 | 23 | 30 | 1 | 1 | 1 | 1 | 1 |
17FAD312548B70250A4C98A6 | Jayo | EMEA | BE | COMMERCIAL | 2019-Q2 | 107 | 108 | 10 | 29 | 44 | 1 | 1 | 1 | 1 | 1 |
19D21607552EBC000A4C98A2 | Livepath | ASIA | AU | COMMERCIAL | 2019-Q2 | 78 | 75 | 14 | 17 | 334 | 1 | 1 | 1 | 1 | 1 |
914CA272551D23790A4C98A2 | Mita | AMER | US | COMMERCIAL | 2019-Q2 | 771 | 654 | 63 | 75 | 540 | 1 | 1 | 1 | 1 | 1 |
A66F776A5245B0310A490D44 | Photolist | AMER | US | COMMERCIAL | 2019-Q2 | 673 | 808 | 14 | 51 | 0 | 1 | 1 | 1 | 0 | 0 |
C1FA079F574F01297F000101 | Lazzy | AMER | US | COMMERCIAL | 2019-Q2 | 306 | 273 | 28 | 73 | 418 | 1 | 1 | 1 | 1 | 1 |
D06DE27F546E24D40A4C98A5 | Livetube | AMER | US | COMMERCIAL | 2019-Q2 | 394 | 399 | 59 | 85 | 977 | 1 | 1 | 1 | 1 | 1 |
EB2234B85CF1A76C0A495CD7 | Shufflester | AMER | US | COMMERCIAL | 2019-Q2 | 402 | 455 | 54 | 100 | 193 | 1 | 1 | 1 | 1 | 1 |
42DF2BA2549484FB0A4C98A1 | Realpoint | AMER | US | COMMERCIAL | 2019-Q3 | 2170 | 3 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |
8AA1FCB555A95FD27F000101 | Innotype | EMEA | AT | COMMERCIAL | 2019-Q3 | 719 | 709 | 71 | 81 | 1785 | 1 | 1 | 1 | 1 | 1 |
C2F4D3125489ED960A4C98A6 | Kwilith | EMEA | DE | COMMERCIAL | 2019-Q3 | 12700 | 214 | 23 | 27 | 664 | 1 | 0 | 0 | 1 | 1 |
3D00286D5750980D7F000101 | Tanoodle | AMER | US | COMMERCIAL | 2019-Q3 | 450 | 479 | 29 | 30 | 319 | 1 | 1 | 1 | 1 | 1 |
5741693F544944260A4C98A6 | Chatterpoint | EMEA | SE | COMMERCIAL | 2019-Q3 | 56 | 52 | 12 | 7 | 60 | 1 | 1 | 1 | 1 | 1 |
5AE4E38C5474FC7E0A4C98A7 | Skynoodle | AMER | US | COMMERCIAL | 2019-Q3 | 277 | 104 | 3 | 4 | 153 | 1 | 1 | 0 | 1 | 1 |
F718199053220B9F0A490D4C | Mycat | AMER | US | COMMERCIAL | 2019-Q3 | 308 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |
4A7BC38E5494B4220A4C98A2 | Einti | AMER | US | COMMERCIAL | 2019-Q3 | 1300 | 1673 | 19 | 48 | 144 | 1 | 1 | 1 | 1 | 1 |
HI @Anonymous ,
From your data, I found that there are fewer fields, such as Accounts Purchased/Under 30 Days into Contract, and the calculation logic of measure in the template is harder to find.
As mentioned in the previous reply, if the rows in your template matrix are hierarchical measures, this is hard to achieve. Based on the results you want to achieve, I think you can try to create a disconnected table, check out this article: Measures on Rows – Here is How I did it
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi @Anonymous ,
May be these post helps you.
https://community.powerbi.com/t5/Desktop/unpivot-with-multiple-measures/td-p/352225
https://community.powerbi.com/t5/Desktop/Unpivot-Measures-for-categorical-chart/td-p/483657
Thanks,
Tejaswi
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |