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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Line Chart not showing line using measures

Hi All,

 

Am facing challenge in line chart which is using two measures as values and year month as X axis. Line chart displaying trend using one measure but not the other one. But I can able to view the  two measure values, and X axis column in show data option in Line chart.  Could you help ?

 

Note: One of the measure is calculated using Selected Value and Switch statement.PowerBI-Issue.JPG

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Issue resolved. It is because of data type mismatch.

View solution in original post

3 REPLIES 3
Tahreem24
Super User
Super User

I have created some sample from your data and perform the same result so I am able to see the both the lines.

You can also try to make the data point available on your chart.

 

 

Capture.PNG

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
Tahreem24
Super User
Super User

As you can see that there are slightly difference in both the values. In order words they are almost same values with slightly different. this is due to scaling of Y-axis.  There is nothing wrong with your measure which you have created just try to change the chart to Bar chart or Line and Stacked column chart so you'll see the both the measure. 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
Anonymous
Not applicable

Issue resolved. It is because of data type mismatch.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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