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
I am pulling data from 2 tables
Table 1 - "plan"
Team | Activity | Cost |
A | Webinar | 100 |
A | Podcast | 150 |
A | Video | 25 |
B | Webinar | 50 |
B | Paid Media | 200 |
Table 2 - "actual" (this table does not have activity and team broken down into unique columns.
Program | Cost |
Ops - A- Webinar | 25 |
Ops - A - Podcast | 300 |
Ops - A - Video | 5 |
Ops - B - Webinar | 10 |
Ops - B - Paid Media | 350 |
I would like to creata a cluster chart showing 'plan' vs 'actual' for each activity. Team names are filters on the dashboard. How can I parse out initial text from table 2 such that I can group these activities by Team ?
Thanks
Solved! Go to Solution.
Hi @saipawar
You can use Power Query very easily to achieve this. Just go to either Transform or Add Column (use Add Column if you want to keep original column) and then click on Extract "After Delimiter" like below. Add the "-" and click okay.
Once you have done the above, you can use "Trim" in the "Transform" tab under "Format" to clean up any blank spaces.
Hope this helps 🙂
Theo
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
Hi @saipawar
You can use Power Query very easily to achieve this. Just go to either Transform or Add Column (use Add Column if you want to keep original column) and then click on Extract "After Delimiter" like below. Add the "-" and click okay.
Once you have done the above, you can use "Trim" in the "Transform" tab under "Format" to clean up any blank spaces.
Hope this helps 🙂
Theo
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |