cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ddtblar Regular Visitor
Regular Visitor

how to use measure as X-axis in line chart

hi guys, need help.

So i try to create line chart that use measure as X-axis and ID as Y-axis.

this is how the power BI try to create the line chart, but it didn't show what i want.

 

how to create diagram from measure.PNG

 

the power BI use ID as X-axis. I want ">60 sal", "60 sal LM", "60 sal LM1" etc. as my X axis, because it shows the saldo in every month category. i want to know wether the saldo last month (LM) is increase or decrease compare to the saldo 2 month ago (LM2).

so i want to show the chart just typical like this:

chart goal.PNG

 

can anyone show and halp me?

your help will be very helpful for me

thanks 

 

 

1 REPLY 1
Thejeswar Senior Member
Senior Member

Re: how to use measure as X-axis in line chart

Hi @ddtblar,

You cannot use a Measure in X-axis. For any column to be used as an axis value, it should be a category. i.e. You should be able to group your entry data based on that column.

 

So in this case, since this column is a Measure, try to create a column that has these values and can be used to group your data by that. 

 

Take inspiration from Pivot Table option to achieve this...

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 123 members 1,378 guests
Please welcome our newest community members: