How to create a Panel

Panels are groups of slicers. They are used so that you can select slicers to filter your report. You can only use one panel at a time, but you can put as many slicers into a panel as you want and the same slicer can be put into as many panels as you want.

 

Loading your database

media_1260450801568.png

Load one of the DBs used in the previous lessons:

(1) Click on the Vizubi tab in the ribbon.
(2) Click on the Open button in the Database group.
(3) Browse until you find "C:\Documents and Settings\All Users\Documents\Vizubi\SampleData\" then select "getting started.ndb".
(4) Click on the Open button to load the file.

 

Open the Vizubi Editor

media_1260450900700.png

(1) Click on the Edit button in the Database group of the ribbon. This will open the Vizubi Editor.

 

Opening the New Panel window

media_1260523700738.png

(1) Click the Panels button in the Navigation Pane.
(2) Click the New Panel in the New group.
(3) The New Panel window opens.

 

Naming the panel

media_1256639534242.png

(1) Insert a Name (no spaces or special characters).
(2) Add a Label and/or Description.

 

Adding slicers to the panel

media_1260524063556.png

(1) Click the Add button.
(2) The Select: Slicers window opens.
(3) Double click on the slicer you want add (you can add multiple slicers using CTRL+click and clicking on OK).

 

Saving panel

media_1260524708393.png

(1) The slicer(s) you selected have been added to the Panel window.
(2) Click the Save and Close button to save the panel (click Save and New if you want to save your panel and create another one as well).

 

View result

media_1260524805786.png

(1) The new slicer has been added to the list.
(2) Click on Switch to workbook to go back to Excel.

 

View panel in Excel worksheet

media_1260524995455.png

(1) Click on the Panels button in the Panels group of the ribbon. The Select panel window opens.
(2) The created panel is available in the list. Double click on it.
(3) The panel opens on the left and is ready to be used with reports.

Need more help?