Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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?

 

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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.

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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.