https://store-images.s-microsoft.com/image/apps.1705.c6666ac3-820e-4ffe-a4ef-a04020fb201d.09c5cc4f-ba54-4672-a556-f59989855028.3f63bff9-d1f2-4013-a033-e7127e5c5f86
Customable Table
by Data SL Consulting
Highly interactive and customizable table visual
Here’s a complete overview of its capabilities:
1. Dynamic Table Structure
Multiple Columns: Supports dynamic addition and removal of columns, with customizable column titles (up to 20 columns).
Manual and Data-Driven Rows: Displays both data-driven rows (from your dataset) and manual rows that can be added by the user for custom calculations, notes, or summaries.
2. Drag & Drop Row Reordering
Reorder Rows: Users can drag and drop rows to reorder them within the table, including both data and manual rows.
Multi-Column Support: Rows can be moved between columns, allowing for flexible organization of data.
Optimistic UI: Changes are reflected immediately in the UI for a smooth user experience, and are persisted in Power BI after saving.
3. Inline Floating Toolbar for Row Formatting
Contextual Toolbar: Clicking a row brings up a floating toolbar for quick formatting.
Text Formatting: Change font size, font family, bold, and italic for both label and amount cells.
Color Customization: Instantly change text color and background color for both label and amount cells using color pickers.
Margin and Spacing: Adjust top and bottom margins for each row to control spacing.
Custom Labels and Amounts: Rename any row or override its displayed value directly from the toolbar.
Hide/Show Rows: Instantly hide or show any row without deleting data.
4. Advanced Format Pane Integration
Full Format Pane Sync: All formatting options (colors, font, margins, etc.) are available and synchronized in the Power BI Format Pane ("Personnalisation").
Live Sync: Changes made via the toolbar are reflected in the Format Pane and vice versa.
Per-Row Formatting: Each row can have its own unique formatting, including custom colors, font, and visibility.
5. Manual Row Management
Add/Remove Manual Rows: Users can add up to 40 manual rows, each with its own label, value, formatting, and position.
Manual Row Properties: Manual rows support all the same formatting and drag & drop features as data rows.
6. Column Management
Add/Remove Columns: Easily add or remove columns with a single click.
Custom Column Titles: Set custom titles for each column via the Format Pane.
7. Table Borders and Layout
Custom Table Borders: Adjust border width, color, style (solid, dashed, dotted, double), and border radius for the entire table.
Responsive Layout: The table layout adapts to the number of columns and available space.
8. Optimistic Persistence and Undo
Optimistic Changes: All user actions (formatting, reordering, etc.) are applied instantly and saved to Power BI when the dashboard is saved.
Pending Changes: The visual keeps track of unsaved changes and ensures they are not lost on refresh.
Undo Support: If Power BI overwrites a change, the visual can reapply the user’s last action for a seamless experience.
9. Accessibility and Usability
Keyboard and Mouse Support: All actions are accessible via mouse, with clear visual feedback.
Tooltips and Hints: Buttons and controls provide tooltips for better usability.
Sticky Headers: Column headers remain visible when scrolling.
10. Styling and Theming
Custom CSS: The visual uses a modern, clean design with customizable styles.
Shadow and Rounded Corners: Subtle shadows and rounded corners for a professional look.
11. Power BI Integration
Selection and Context Menu: Integrates with Power BI’s selection manager for context menus and interactions.
Data Binding: Fully supports Power BI’s data roles for categories and measures.
This visual
is a feature-rich, user-friendly table visual for Power BI, offering advanced formatting, drag & drop organization, manual row management, and deep integration with the Power BI Format Pane. It is ideal for financial statements, custom reports, and any scenario where users need maximum flexibility and control over their table layouts and styles.
Visual capabilities
When this visual is used, it
- Can access external services or resources
At a glance
https://store-images.s-microsoft.com/image/apps.9980.c6666ac3-820e-4ffe-a4ef-a04020fb201d.09c5cc4f-ba54-4672-a556-f59989855028.5462537f-19d0-4353-b31d-7ee7325b1d85
https://store-images.s-microsoft.com/image/apps.57000.c6666ac3-820e-4ffe-a4ef-a04020fb201d.09c5cc4f-ba54-4672-a556-f59989855028.fa15e982-5286-425c-9da3-29e0b52205f6