Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |