Forum Discussion
Stop Summarising Data in visualisation
Without seeing your data model or PBIX file it is hard to answer, but my guess is that if you are using weeks as the axis, there are multiple prices per week for a given product, and thus you will get some aggregation (i.e. average). You need to have exactly one data point per product per store for every X axis increment to avoid aggregating.
Try creating a new column:
[Year]*100+[Week]
This will give you an index, i.e. 201701, 201702 etc. Use this as your axis and see if it works better.
Feel free to share the PBIX if you want a more precise answer (or give us your data, anonomyzed is okay).
dkay84_PowerBI - thanks for the reply. I've tried that, i think i'm getting somewhere.
But I have had to adjust my expectations, and have applied a filter for each store to see individual product level data. At the aggregated level it shows average product price per store, which is probably still quite interesting.The next problem I have is that, because the price changes are so small and relatively infrequent, the chart looks pretty flat. Is there a good way to amplify the appearance of the line, to exaggerate the changes?
v-yulgu-msft- thanks for you reply too. That matrix looks exactly like the one I've managed to create... I think I'm finally getting there.
