Forum Discussion
Helper IIIuse top10 projects of dynamically selected month to plot same projects over time
So I kinda found a solution for my problem, by first creating a bridge table of Headers:
ListHeaders = VALUES('Table'[Project Header])and then a summarize table
Top10Sales=SUMMARIZE('Table', 'Table'[Project Header], 'Table'[Project Currency], 'Table'[Year], 'Table'[MonthEndDate]
that populates the Sparklines after relationships were established between
Table & ListHeaders
ListHeaders & Top10 Sales
Dim table 'Currency' & Top10Sales.
This is neither elegant nor efficient as I am duplicating lots of data, please feel free to enlighten me on filtering temp tables.
Helper IIIamitchandak unfortunately that changes nothing. The ranking in the table for each month is correct. The Sparklines are the top 10 projects of all time and don't correspond to the ones in the table for the selected month.
I also created a separate date table so the slicer date and the axis date in sparklines would be different.
Helper IIISo I kinda found a solution for my problem, by first creating a bridge table of Headers:
ListHeaders = VALUES('Table'[Project Header]) and then a summarize table
Top10Sales=SUMMARIZE('Table', 'Table'[Project Header], 'Table'[Project Currency], 'Table'[Year], 'Table'[MonthEndDate]
that populates the Sparklines after relationships were established between
Table & ListHeaders
ListHeaders & Top10 Sales
Dim table 'Currency' & Top10Sales.
This is neither elegant nor efficient as I am duplicating lots of data, please feel free to enlighten me on filtering temp tables.
- v-xulin-mstf
Community Support
Hi MelStaunton,
Congratulations on finding a solution!
If the issue has been solved, please adopt your final solution to help others.
Best Regards,
Link
