Creating line chart where X and Y axis values come from same column

[Anonymous]

I have a sample dataset below which i have imported into PowerBi. I want to be able to create a line chart from the data highlighted in green but struggling to figure out how. Anyone have ideas or do i need to seperate this data out?

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

I can reproduce your problem as below

Create a measure

Measure =
CALCULATE (
    SUM ( 'Table'[value] ),
    FILTER (
        'Table',
        'Table'[industry]
            = MAX ( 'Table'[industry] )
            && 'Table'[category] = "client revenue"
    )
)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.