Great for displaying multiple KPI values in a single visual.
The Multi KPI is a highly customizable visual.
This Multi KPI allows you to track a Sales Amount KPI with the supportive measures of Quantity, Cost, and Tax shown as sparklines.
Under theFormatpaintbrush you will find there are several customizations that you can enable for this visual.
Using theDatesection you can change the formatting of the date in the visual.
Under theValuessection you can change the formatting for each of the chart measure values.
Using theY Axisproperties you can change the appearance of the Y Axis on each chart. You should know that by default only the main chart has a Y Axis that is visible.
Changing theMain Chartsection allows you to adjust the shading and style of the main chart on the top of this visual.
TheTooltipsection allows you to modify what is displayed for the tooltip on each measure.
Modifying theKPIsection adjusts the appearance of the main KPI display.
TheKPI On Hovercan change the appearance of the KPI when a cursor hovers over the KPI.
Turning on/off theSparkline Gridproperty changes the default behavior where the KPI display can change when you hover over a sparkline.
Use the Position property under theSparklinesection to change the order of the sparklines in the visual.
Adjusting theSparkline Nameproperty allows you to customize the formatting on the chart name.
Changing theSparkline Chartsection allows you to adjust the shading and style of each sparkline.
Under theSparklineValuesection you can change the formatting for each of the chart measure values.
Using theSparkline Y Axisproperties you can change the appearance of the Y Axis on each chart.
TheSubtitlesection allows you to add text below all the charts to describe what the visual is displaying.
Changing thePrint Modeoption makes the visual more print friendly when you select Export to PDF.
You can also adjust the background color, add a border around the visual and lock the aspect ratio under the Format section.
Find Out More
You will always be able to find this video module and advanced viewing of future modules on the Pragmatic Works On-Demand Training platform or view my previous blog posts.
Join Our Blog
Join thousands of other SQL Server, BI and cloud pros by subscribing to our blog.
• Microsoft MVP
• Leads all training programs for Pragmatic Works
• Business Intelligence consultant with work experience building SQL Server data warehouses
• Experience building SharePoint BI solutions with Excel Services, PowerPivot, PerformancePoint, Reporting Services and Power View
• Work daily with entire BI stack: SSIS, SSAS, SSRS for SQL Server
• Speaking history at multiple SQL Saturdays, SQL Rally and PASS Summit
• Planned and implemented Both proof of concepts and full production ready BI solutions.
• Professional Association for SQL Server (PASS) member
• Leads the Jacksonville SQL Server User Group
• Author of 6 SQL Server books
Leave a comment