cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
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
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 325 members 3,881 guests
Please welcome our newest community members: