Forum Discussion

erihsehc's avatar
erihsehc
Icon for Helper III rankHelper III
8 years ago

change chart axis label by measure

hi there,

 

waterfall created as below

 

 

a table created for the waterfall axis, c t1 t2 t3 t4...

t1=>top1 = iferror(CALCULATE(SUM(BO_wf_DataSet_2_New[Variance]),FILTER(ALLSELECTED('customer (2)'[Group Customer]),[Ranking by sales new]=1),ALLEXCEPT('customer (2)','customer (2)'[Group Customer])),BLANK())

 

 

the waterfall axis item mapping with the below measures:

wf2 cal = if(LASTNONBLANK('waterfall 2 item'[item],1)="c",[Val1 total],if(LASTNONBLANK('waterfall 2 item'[item],1)="t1",[top1],if(LASTNONBLANK('waterfall 2 item'[item],1)="t2",[top2],if(LASTNONBLANK('waterfall 2 item'[item],1)="t3",[top3],if(LASTNONBLANK('waterfall 2 item'[item],1)="t4",[top4],if(LASTNONBLANK('waterfall 2 item'[item],1)="t5",[top5],if(LASTNONBLANK('waterfall 2 item'[item],1)="t6",[top6],if(LASTNONBLANK('waterfall 2 item'[item],1)="t7",[top7],if(LASTNONBLANK('waterfall 2 item'[item],1)="t8",[top8],if(LASTNONBLANK('waterfall 2 item'[item],1)="t9",[top9],if(LASTNONBLANK('waterfall 2 item'[item],1)="t10",[top10],if(LASTNONBLANK('waterfall 2 item'[item],1)="t11",[top other],if(LASTNONBLANK('waterfall 2 item'[item],1)="b",[Val2 total])))))))))))))

 

BI shows the above waterfall using the above, item column=>category, wf2 cal=>Y Axis

actually, the t1 t2 t3...means the top customer, 2nd top customer (the top 10 customer is dynamic, depending on the slicer selection)...., I would like to show the customer name instead of t1 t2....on axis, how to do that? thanks

 

Best regards,

ER