Forum Discussion
Using the fields from a secondary data source to filter primary data set in Power Pivot
I developed a set of PowerPivot tables in Excel 2010. These will retreive all the data from the beginning and use Slicers to filter interactively. Now I need to; 1. limit the result set via prama...
I would take a look at building this in Power BI and using Power BI Embedded perhaps or the "Publish to Web" feature to put it on the website. For the date filtering, using the custom Timeline Slicer visualization available in the gallery.