Forum Discussion
Wrong data on the chart
Hello!
Please, help to understand what's the problem.
I have merged new column to a table and then I've calculated with it one new custom column in Power Query. Everything is perfect, BUT...
On the chart this column is showed by date and every value from the column of Power query is divided on 2 on the chart!
Please, tell me what's wrong with it?
Thanks!
Lower are the links on the screenshots of table and chart.
As the example you can look at the value on the 22nd of april.
The same is with the other calculated columns((
18 Replies
Hi,
Some screenshots would help in understanding the problem better.
ri2sina I don't think this is related to custom column you've created since for the visual in screenshot you're not using data from custom column. It is hard to guess a problem looking at the screenshots provided. Can you do some more troubleshooting.
Can you drop Revenue total and date fields onto a table visual and provide that screenshot. Make sure from the fields dropdown you select 'Do not summarize' ?
the native table was
then i have filtered rows, merged queries and expanded new columns
then i have created new column
then merged queries again by date and currency
and aggregated new column Sum of rate
added custom again Revenue total
and groupped rows
Hi ri2sina,
As other post, please drop Revenue total and date fields onto a table visualization and provide the screenshot, and make sure the Revenue total field is set to “Don’t summarize”, below is a similar screenshot for your reference.
Moreover, check the function that is used for Revenue total field in your Line Chart visualization, which is similarly shown as the following screenshot.
Thanks,
Lydia ZhangHello Lydia!
If I understand you correctly, please check this link.. Am I?
And i haven't got ''don't summarize" field(
