Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Create a Hierarchy or group from Text in one column

I have a situation I have not found an answer to. I have found some close ones but this is project data coming from Smartsheets that I need to be able to classify and report on in a varity of graphs, charts, tables and the like. The project was not setup particularly well but it is what i have to work with.  

I have standard project type columns with name, start, finish % complete, status etc. The first 2 columns are the keys (I think) as I need to group the  milestones and tasks under each sub workstream/process so I can report on the status of each sub workstream - almost like mini projects  so think of project type reporting where everything is in one giant project.  

 

So is it possible to use the table below to be able to report on status, %complete etc by sub process - hence the grouping need.  

 

Any help would be helpful as I am lost. 

Ref #ClassificationDescriptionStartFinish% completeStatus
9.1Sub-ProcessFor a  sub process this is the subprocess nameSummary date (like any project tool)Finish date Started, red, yellow, green
9.1.1Milestone     
9.1.1.1Task     
9.1.1.2Task     
9.1.1.2.1Subtask     
9.1.2Milestone     
9.1.2.1Task     
9.2Sub-process     
9.2.1Mileston     
1 REPLY 1
Anonymous
Not applicable

Some of the visuals I need to have are like the following hence the need for grouping. Of course there are others. the blacked out names are the sub-worksteram names. (This is from a differnet report) 

bleake58_0-1679524688316.png

bleake58_1-1679524744313.png

 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.