Forum Discussion

TristanO's avatar
TristanO
New Member
8 years ago
Solved

Grouping Data from one column to create graph

Hi All,   I am attempting to create a pie graph to show management how many hours are being billed out by each department but in order to do that I need to group together multiple job codes that ar...
  • Anonymous's avatar
    Anonymous
    8 years ago

    TristanO,

    Create a column using DAX below in your  table.
    GroupName = LEFT(Table[Job Code],FIND("-",Table[Job Code])-1)

    Then create a pie chart as follows. When new job codes are added, just click "Refresh" button in Power BI Desktop to bring the new data.


    Regards,
    Lydia

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

You may also split data in the Query Editor window by using - as a delimiter.