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... ...
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