Forum Discussion
Change tracking between dates
Look at the below example. I have a basket of fruits and I update the fruits and the price everyday. One day I have 4 fruits and the next day I am missing the orrange. Prices are also different. ...
Hey Sertan_CPH ,
I consider the Ribbon chart a good fit for this data visualization task:
In regards to visualizing a complete year, I recommend creating a dedicated Calendar table, and create a relationship between the Calendar table (the one-side) and your table (the many-side). Then you can use the Calendar table on the x-axis of the ribbon chart.
This article also contains how to create a Calendar table: Time patterns – DAX Patterns
Hopefully, this helps to provide some ideas on how to tackle your challenge.
Regards,
Tom
TomMartens Hi
It is very practical and I really like this method but as you can imagine my data is very large and not only few fruits but 1000 line items. It is simply too confusing to use ribbon chart in this case