Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
erihsehc
Helper III
Helper III

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
Employee
Employee

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.