Skip to main content

Build and Publish a Revenue Dashboard

Create a chart of current and prior revenue and a KPI that responds to a region selection. Start with the sample orders table. The revenue flow adds the prior-year comparison, and you can use the table directly if Data Flows is unavailable.

Create the workbook and data sources​

  1. In Dashboards, choose New dashboard and name it Regional service revenue. Open Edit dashboard.
  2. In the dashboard filter bar, choose Add parameter. Name the select control region. Add East, Central, and West as separate lines under Options. Leave its default blank to start with all regions.
  3. For the comparison chart, open the flow's Published output and select Add to a dashboard. Attach the version to the workbook you created. Return to the dashboard.

If you are building directly from the table, open Data, create a dataset in Visual builder, and choose studio_orders under Source & relationships. In Preparation & measures, filter report_year to 2026. Add Group and measure, add region as a dimension, and sum revenue as current_revenue. Preview three rows, then save the dataset. The bar chart will have one series.

Add the chart and KPI​

  1. Choose Add widget and select Bar. Set its title to Revenue by region. Under Data source, select Dataset and choose your attached or visual dataset. Bind the category to region and the value to current_revenue. If your source includes prior_revenue, add it as a second series where supported, or add a table below the chart with both amounts. Save the widget.

  2. Open Data and create another dataset named Current revenue KPI. Use Visual builder with studio_orders as the source.

  3. In Preparation & measures, add Filter rows with both of these conditions:

    FieldOperatorValue typeValue
    report_yearEqualsNumber2026
    regionEqualsDashboard filterregion

    Enable Allow all values for the region condition. Add Group and measure with no dimension and sum revenue as current_revenue. Preview dataset should return one row with 7000. Save it.

  4. Add a Metric widget titled Current revenue. Select Current revenue KPI as its dataset and bind the value to current_revenue. Set the number format to currency and save the widget.

Make the chart interactive​

Open the bar widget editor. Under Click to filter, enable Bind marks / rows to a filter. Set Clicked column and Target filter name to region, then choose the Dashboard filter bar scope. Save the widget. The bar chart keeps the comparison across regions, and the KPI uses the selection to show the chosen region's revenue.

Choose Done editing and check the KPI as you change the filter or click a bar:

SelectionCurrent revenue KPI
All$7,000
East$3,000
Central$2,300
West$1,700

If the dropdown changes but the KPI stays at $7,000, check that the KPI dataset condition uses value type Dashboard filter and the name region. If the dropdown works but clicking a bar does not, confirm the chart includes region in its output and the action uses the dashboard filter bar scope.

Publish and check the viewer experience​

Open Share and select Publish current draft. Open the workspace link with an authorized viewer account and select Central. Confirm the KPI displays $2,300. Open Present and repeat the check, then clear the selection and confirm $7,000. If the chart uses a flow output, verify the viewer also has access to that flow version, connection, and sample table.

See Layout, Filters, and Interactions for styles and additional actions, and Publish and Share a Dashboard for release and sharing options.