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.
Hello everyone reading this question. I apologize if this has been answered in some other post, but I wasn't able to find exactly how to do what I'm looking for.
Here is a sample of my data.
My goal is to make a visual that shows the sum of the [BytesReceived] and [BytesSent] by date and to also not have it separated by [Location]. I assume the best way to do this is to create a new table that sums each column by date and leaves out the [Location], like this.
I'm not sure how to get from the sample data to the new table using a formula or if that is even the best way to go about doing this. These examples were made in Excel for illustrative purposes, but I would need to be able to do this in Power BI. Any suggestions on how I can/should do this?
Solved! Go to Solution.
Just create a Table visualization with only those 3 columns in it and not location.
Hi @Gnaglor,
Have you tried the solution provided by @Greg_Deckler above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?
If you still have any question on this issue, feel free to post here.
Regards
Just create a Table visualization with only those 3 columns in it and not location.
Thank you! This worked perfectly.
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |