Forum Discussion
Issue in chart with month start letter
"Don't Summarize" option could be used on the Table, but not the Line and stacked column Chart.
Alternatively, we can put the month number field into the Column series of filed to work around. For more information, please check the pbix as attached.
Regards,
Lydia
Based on my test, the values will be summed up automatically for the month which are repeated letters.
Here I suggest you to use Month number instead of the start letter of Month. Through that we can get the correct column chart as below.
For more information, please check the pbix as attached.
Regards,
Lydia
Lydia,
Thanks for the response.
Its works fine when used month number or month full name or month 3 chars.
But issue is with month first character.
Our requirement is to use first character of the month.
It works fine with SAP Lumira designer but with Power BI the values are getting cumulated.
Is there any other solution.
Regards,
Ugandhar
"Don't Summarize" option could be used on the Table, but not the Line and stacked column Chart.
Alternatively, we can put the month number field into the Column series of filed to work around. For more information, please check the pbix as attached.
Regards,
Lydia