change chart axis label by measure

[erihsehc]

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

[v-huizhn-msft]

Hi @erihsehc,

From what I know, changing x-axis label by measure dynamically is unsupported in Power BI to date, please review the following feature request and vote them.

dynamic axis scaling
Allow formulas to be entered for all reference lines in the Scatter Chart

Best Regards,
Angelia