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.
Hi , Please I have a Table in this format(FROM) and I will like to count it and group up in this format(TO), is this a
modelling issues . I tried to use a matrix but it will only work for a column. Thanks
Solved! Go to Solution.
Hello @Anonymous ,
This would be easier if you can unpivot columns in edit query,
Select columns and click Unpivot Columns option under Transform menu in edit queries, this will change your dataset in preferred format for your visualization
let me know if it helps.
Thank You,
Washivale
I believe what you need to do is unpivot your data.
This can be achieved by using the query editor and selecting unpivot columns in the transform tab. (See below)
After this you may need to rename some of the columns, but the when you have this done, You can throw the corresponding columns into a matrix.
I believe what you need to do is unpivot your data.
This can be achieved by using the query editor and selecting unpivot columns in the transform tab. (See below)
After this you may need to rename some of the columns, but the when you have this done, You can throw the corresponding columns into a matrix.
Hello @Anonymous ,
This would be easier if you can unpivot columns in edit query,
Select columns and click Unpivot Columns option under Transform menu in edit queries, this will change your dataset in preferred format for your visualization
let me know if it helps.
Thank You,
Washivale
Thanks
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |