Hi
I have spent days searching power Bi help and forums but am unable to find how to do this seemingly easy task.
Requirment:
Produce a combined stack chart showing the average values per item for date >= 2017/01/01
Then the second stack to show today's totals matching against the items listed above. This is very useful for daily reports so one can get an immediate indicator of any major peeks or dips every day.
Attempted resolution:
Calculated column in the Power query that flags the rows relating to TODAYS data.
Issue:
When selecting combined chart there is only one filter that acts against both data sets, Unfortunatley if I select the
column flagged for today's date then I only see that data for both values in the combined chart.
What I would like to do is have a separate filter for the years average values and the current filter for today's values.
And then hope the values can also by matched just for what is appearing in today's data.
Other Methods
I know this may be achievable from the power query though this will cause huge overhead having to do a voolkup or Match across 10,000+ rows for each row each day to re calculate the averages for all unique items.
Is there any other way of achieving this task?
Thanks to all
