measure not working on line chart

[shei7141]

hi all,

I have a very strange situation. I have a measure and when I plot it in a table the values are shown but when I try to map them into a line chart no values are visible.

values in table

nothing in line chart or bar chart

[v-diye-msft · Accepted solution]

Hi @shei7141 

1. Please make sure the measure was set as numberic type.

2. Please put the measure in the values tab.

Please also note the limitation:

• One line chart cannot have dual Y axes. You'll need to use a combo chart instead.
• In the examples above, the charts were formatted to increase font size, change font color, add axis titles, center the chart title and legend, start both axes at zero, and more. The Formatting pane (paint roller icon) has a seemingly endless set of options for making your charts look the way you want them to. The best way to learn is to open the Formatting pane and explore.

If not help, please kindly elaborate more.

[amitchandak]

@shei7141 , Check the format of the data. Id it number or text. It should be a number.

What is the axis you have taken on the line. With that Axis are you getting data in a table visual?

Check for any page/visual level filter. Or create a new page new visual and try.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[negi007]

@shei7141  Can you share your sample data. To be able to show data on line chart, you need to have atleast data for two months. Line chart will not appear if you have only one data points or data for only one month. To answer your query, i suggest you to share sample data by months. 

Follow me at https://www.linkedin.com/in/pramod-negi-1858aa15/

[AntrikshSharma]

Will you be able to provide the PBI file? It is difficult to say why you are getting the error. Are there any additional filters active on the line chart?