So far, we have made a lot of progress building a really sharp report for our sales productivity dashboard with a variety of different visualizations. Now, let's keep it going and add a bit of interactivity. At the end of the day, what would a dashboard be if you could not carve up the data the way you wanted to see it?
The Power BI Designer and Power BI for Office 365 provides a native functionality to create a truly interactive user experience in order to analyze the report data. In this chapter, you will learn the basics of how to add the interactive querying functionality to the reports, using a variety of different data filters and slicers.
We need to prepare the reports for presentation in the sales productivity dashboard by sorting our top customer revenue, making sure Lost Products by Territory only displays the deals that we lost. Next, we should be able to look at the deals closed real time by year, quarter, and/or month....