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.
I'm banging my head against the wall on this one. I thought it would be easy, but for some reason I cannot get it to work.
Consider the following table
timestamp | Instrument A | Instrument B | Instrument C | Instrument D |
10.01.2021 10:00:00 | 5 | 6 | 9 | 9 |
10.01.2021 11:00:00 | 6 | 2 | 3 | 9 |
11.01.2021 10:00:00 | 7 | 7 | 4 | 9 |
12.01.2021 10:00:00 | 5 | 3 | 3 | 4 |
13.01.2021 10:00:00 | 3 | 8 | 7 | 8 |
14.01.2021 10:00:00 | 9 | 6 | 3 | 4 |
14.01.2021 11:00:00 | 4 | 4 | 8 | 4 |
What I want to do is
1. Sum the value of each colum (in this case that would be 39, 36, 37, 47 from left to right)
2. Show the sums in an 'Top N' chart sorted decending
In my real world case I have some 20 columns and 50000 rows, but the principle is the same.
Any tips ?
Solved! Go to Solution.
Hello,
i have tried out this topic and i think i have way you can do it.
What i did is, i went into PowerQuery and unpivoted the table
First it looks like your table and afterwards like this screenshot:
And this would already work for getting the horizontal bar chart
Axis would be your Attribute (Instrument)
Value the Value
Now you can add a Top N Filter on the visualisation.
Does this help you?
Cheers
Tyree
Thanks for your feedback 🙂
Yeah, this would probably work. My current problem is that all the columns are calculated colums in DAX. The columns does not excist in the power query environment. So using your solution I would need to be able to make the calculated colums in power query. It can probably be done.
The "less work approach" would be to do this in DAX, if possible 🙂
Hello,
i have tried out this topic and i think i have way you can do it.
What i did is, i went into PowerQuery and unpivoted the table
First it looks like your table and afterwards like this screenshot:
And this would already work for getting the horizontal bar chart
Axis would be your Attribute (Instrument)
Value the Value
Now you can add a Top N Filter on the visualisation.
Does this help you?
Cheers
Tyree
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 |
---|---|
46 | |
22 | |
20 | |
15 | |
13 |
User | Count |
---|---|
49 | |
41 | |
39 | |
19 | |
19 |