Line chart with two measures 2nd measure not displaying properly in the chart

[Anonymous]

Hi Experts, i am new to the power BI and now i am facing one issue while creating line chart with 2 measures. Logic for measure: 1.Loyality = Calculate(Count(Customers),filter(Tablename,loyality flag = "Y") 2.NON-Loyality = Calculate(Count(Customers),filter(Tablename,loyality flag = "N") using above two measure line chart created the values are matching for Loyality customers count but for the Non-loyality line the values are displaying like suppose take a Jun 2020 month day wise..10th jun 2020 having value as 20 in the backend but in the chart the 20 value is showing for the some other day like on 18th jun 2020 showing 20 as a value in the line chart . for the i have already set x axis type as categorical still same issue. Kindly help me on this issue. Thanks lot

[Anonymous]

Hi @Anonymous ,

Try test Table visual or other visual and see if the problem exists. And what's your x-axis in the visual? Better to share more information to us since we can't reproduce your scenario.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Jay,

Thanks for the information.

i have tried different ways like re-creating of visual and calculation but no use getting same issue and in my visual Y-axis is showing Count fo customers and X - axis showing days like 1,2,3,4,5...31.

Thank you.

[amitchandak]

@Anonymous , This should work, unless there is filter on the page.

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