Getting ready

To prepare for this recipe, do the following:

1. Open Power BI Desktop.
2. Create a table called R01_Revenue using the following formula:

R01_Revenue = GENERATESERIES(1,1000,1)

3. Create a table called R01_Cost using the following formula:

R01_Cost = GENERATESERIES(1,1000,1)

4. Create a table called R01_GrossMargin using the following formula:

R01_GrossMargin = GENERATESERIES(.01,1,.01)

5. Create a Slicer visualization using the Value column of the R01_Revenue table and rename the column in the Field area of the visualization from Value to Revenue.
6. Create a Slicer visualization using the Value column of the R01_Cost table and rename the column in the Field area of the visualization from Value to Cost.
7. Create a Slicer visualization using the Value column of the R01_GrossMargin table and rename the column in the Field of the visualization area from Value to Gross Margin.