Microsoft Power BI Cookbook

Base graphics histogram

1. In Power BI Desktop, unhide the Product Key column of the Product table--the column used in relationships to fact tables.
2. Add the Calendar Year Status column from the Date dimension table to a Page or Report level filter and set the filter condition to the current calendar year.

Page Level Filter

• See Chapter 6, Getting Serious with Date Intelligence for details on dynamic date columns.

3. Click on the R script visual from the Visualizations pane to add it to the canvas.
4. Add the Product Key and List Price columns from the Product table to the Values field well of the R script visual.
5. Now add the Internet Net Sales ...