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

Anonymous's avatar
Anonymous
Not applicable
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