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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
oakfootballclub
Helper IV
Helper IV

how to make x axis in the top of visual

for example, how to move the month on the top of visual rather bottom

oakfootballclub_0-1720165027477.png

 

1 ACCEPTED SOLUTION
wujunmin
Advocate III
Advocate III

Like this?

1.png

The following method requires all data to be positive. In case of negative numbers, you might  use line and clustered column chart to apply a similar logic.

 

First, choose this visual:

 

wujunmin_0-1720167706125.png

Stack the Y-axis by dragging the following three measures:

 

wujunmin_1-1720167772337.png

M.MaxValue-Value = MAXX(ALLSELECTED('DateTable'[Date]),[M.KPI])-[M.KPI]
M.ForX = MAXX(ALLSELECTED('DateTable'[Date]),[M.KPI]) * 0.2
 
M.MaxValue-Value, utilized to bridge the gap between each KPI and the maximum value,
and M.ForX, designated for storing the X-axis labels.
 
To ensure these elements are concealed, set the transparency of the bars M.MaxValue-Value and M.ForX to 100%.
 
wujunmin_2-1720167922211.png

 

Activate the data labels for M.KPI and M.ForX, with the M.ForX data label configured to display the date column and positioned inside the base.
wujunmin_3-1720167976672.pngwujunmin_0-1720168210264.png

 

View solution in original post

3 REPLIES 3
wujunmin
Advocate III
Advocate III

Like this?

1.png

The following method requires all data to be positive. In case of negative numbers, you might  use line and clustered column chart to apply a similar logic.

 

First, choose this visual:

 

wujunmin_0-1720167706125.png

Stack the Y-axis by dragging the following three measures:

 

wujunmin_1-1720167772337.png

M.MaxValue-Value = MAXX(ALLSELECTED('DateTable'[Date]),[M.KPI])-[M.KPI]
M.ForX = MAXX(ALLSELECTED('DateTable'[Date]),[M.KPI]) * 0.2
 
M.MaxValue-Value, utilized to bridge the gap between each KPI and the maximum value,
and M.ForX, designated for storing the X-axis labels.
 
To ensure these elements are concealed, set the transparency of the bars M.MaxValue-Value and M.ForX to 100%.
 
wujunmin_2-1720167922211.png

 

Activate the data labels for M.KPI and M.ForX, with the M.ForX data label configured to display the date column and positioned inside the base.
wujunmin_3-1720167976672.pngwujunmin_0-1720168210264.png

 

rajendraongole1
Super User
Super User

Hi @oakfootballclub -Placing the positioning the X-axis at the top of a visual is not directly supported as a built-in feature.

exploring custom visuals available in the Power BI marketplace or developing a custom visual using Power BI's developer tools. such as but not working the above categories directly in visual.

 

rajendraongole1_0-1720166631404.png

 

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Do you know of any custom visual that could help for the porpuse of positioning X-axis at the top?

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors