Forum Discussion

Helper III

5 years ago

Solved

use top10 projects of dynamically selected month to plot same projects over time

Hello experts! I rank Top10 projects by highest sale. Users can select the months (and other slicers) Whatever projects rank highest for that month I would like to plot a sparkline for all value...

Need Help

MelStaunton
5 years ago
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.

MelStaunton

Helper III

5 years ago

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.