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 there,
I currently have a custom column that groups each associates' total revenue sorted by date. For instance, in the "Total Revenue Custom" column, this has multiple lists for each associate showing their total revenue ordered by the date in which they started. For the purpose of explanation, you can see in the screenshot Month 1 Total Revenue is 0.788; Month 2 Total Revenue is 0.714 etc for that particular associate.
What I wanted to do is to visualise this data. This means that I want all associates' Month 1's total revenue, all associates' Month 2's total revenue data on a line chart. As people started in different months, I felt this was the only way to standardize everyone's data to ensure it is Month 1, Month 2 (any other ways to achieve this would also help!).
However, as I have lists in each cell, I have no idea how I can convert this to a column that has Month 1 which then shows the first row of the list for each associate, then I can do this for Month 2 (with the second row from each associates' lists) etc.
Any help in getting to my solution would be much appreciated 🙂
Solved! Go to Solution.
@ajd33 ,
It seems that you may change type number to list in the code.
@ajd33 ,
It seems that you may change type number to list in the code.
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 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |