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
- In Dashboards, choose New dashboard and name it
Regional service revenue. Open Edit dashboard. - In the dashboard filter bar, choose Add parameter. Name the select control
region. AddEast,Central, andWestas separate lines under Options. Leave its default blank to start with all regions. - 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
-
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 toregionand the value tocurrent_revenue. If your source includesprior_revenue, add it as a second series where supported, or add a table below the chart with both amounts. Save the widget. -
Open Data and create another dataset named
Current revenue KPI. Use Visual builder withstudio_ordersas the source. -
In Preparation & measures, add Filter rows with both of these conditions:
Field Operator Value type Value report_yearEquals Number 2026regionEquals Dashboard filter regionEnable Allow all values for the region condition. Add Group and measure with no dimension and sum
revenueascurrent_revenue. Preview dataset should return one row with7000. Save it. -
Add a Metric widget titled
Current revenue. SelectCurrent revenue KPIas its dataset and bind the value tocurrent_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:
| Selection | Current 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.