cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
erihsehc Member
Member

change chart axis label by measure

hi there,

 

waterfall created as below

waterfall img.JPG 

 

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())

waterfall axis.JPG 

 

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

1 REPLY 1
v-huizhn-msft Super Contributor
Super Contributor

Re: change chart axis label by measure

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

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 42 members 1,023 guests
Please welcome our newest community members: