Forum Discussion

SteveIOW's avatar
SteveIOW
Icon for Helper II rankHelper II
4 years ago

Create an Average point on the x axis

HI, fairly new to PBI so forgive my ignorance.   I a clustered bar chart showing a waitinglist distribution. e.g 10 people waiting 1 week, 5 waiting 2 weeks, 6 waiting 3 weeks and so on. I want to...
Need Help
Datavizuserpbi's avatar
Datavizuserpbi
Icon for Helper I rankHelper I
4 years ago

Hello, 
try this and create a measure = MEDIAN('Table'[Weeks])
it's what you want ?

  • SteveIOW's avatar
    SteveIOW
    Icon for Helper II rankHelper II
    4 years ago

    ah, no I don't think so because my table is already cumulative. i.e.

    WeeksWait , PeopleCount

         1                   10

         2                    5

         3                    6

         4                    3

     

    I think what you suggest will only give me the average of either 1,2,3,4 or 10,5,6,3