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! Pls help as I can not get through this.
I have this data in 'H1 raw data final' table
ID | Domain | Shortmonth | Darab (piece) |
1 | IT | jan | 1 |
2 | IT | febr | 1 |
3 | NW | jan | 1 |
4 | NW | febr | 1 |
5 | IT | febr | 1 |
6 | NW | febr | 1 |
7 | IT | febr | 1 |
8 | IT | jan | 1 |
9 | IT | febr | 1 |
10 | NW | jan | 1 |
11 | IT | febr | 1 |
And would like to create a new table 'Monthlygroupby' like this:
Month | IT | NW | Totalmonth |
jan | 2 | 2 | 4 |
febr | 5 | 2 | 7 |
I have started a new table and managed to create a table with totalmonth, but I do not manage to put in the filtered IT and NW data.
Thanks in advance!
Solved! Go to Solution.
Hi @Anonymous ,
Please see the pictures below. I created a short version of your table. Then dropped the data onto a matrix visualization.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi @Anonymous ,
Please see the pictures below. I created a short version of your table. Then dropped the data onto a matrix visualization.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi @Nathaniel_C ! Thank you very much for putting effort into my small thing 🙂
I will try to make it only with visualization, as I see creating a table requires more knowledge.
I would have one more question. Actually I would like to make visualization out of this: showing the monhtly average / domain.
Here is the matrix (numbers are different):
And I would like to create some visualization like this, but showing the avg per domain (IT, NW). I could do the total avg with a measure like this:
Shall I make measures or is there an easier way to show the avg numbers per domain? Best would be to have a treemap but not with totals but with avg. This is with totals, I could not find how to turn it into avg:
Hi @Anonymous ,
That one is easy, as you have already done the hardwork. Simply go to where you have dropped the columns into the values on the tree visualization. Click the down arrow and select Average. Your tree will be as you desire it to be. See picture below for clarification.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi @Anonymous ,
However if you wish to create a new table, and not a visualization, the easist way is to go back to your original query, rename it. Then
delete the columns you don't want in the new table, (like ID) move the month column and rename it. Then pivot the columns.
Added a picture showing the pivot step. Highlight the Domains column (in my table) and click on Pivot Columns, choose the values I have selected.
Finally add a column called TotalMonth with the totals of the two domain columns.
See my picture below for the code using Adv Editor as well as the final table. If you refresh, this new table will be refreshed as well.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
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 |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
65 | |
50 | |
45 | |
20 | |
17 |