Forum Discussion
Enhance report designs
- 8 months ago
Hi Marico
I’ve worked with similar cases, and when the report has no numeric columns, traditional table visuals will always feel flat no matter how many formatting tweaks we apply.
Here’s a practical approach that improves both interactivity and visual appeal:
✅ 1. Transform the descriptive fields into a “key–value” structured table
Using Power Query or DAX, create a normalized structure like:
Record ID
Attribute
Attribute Value
This gives you flexibility to use visuals other than a standard table.✅ 2. Use a custom visual designed for text-heavy data
The ones that worked best for me are:
Card Browser (AppSource) → turns each row into an interactive profile card
Accordion by Nova Silva → allows users to expand/collapse long descriptions
Deneb (Vega-Lite) → highly customizable for creating clean, app-style text layouts
These visuals display descriptive fields far better than a flat table.✅ 3. Build an “Interactive Info Panel”
With Deneb or Card Browser, each record becomes a card with:
a header
wrapped text
icons or category colors
optional search/filter
This setup feels much more intuitive for end-users.✅ 4. (Optional) Use Tooltip Pages
If the client wants a cleaner layout, keep the main view minimal and show detailed descriptive fields inside a tooltip page when hovering or clicking.
✅ Result
This approach makes the report look interactive, modern, and user-friendly, even though the dataset contains no numeric fields
Hi Marico,
here some ideas:
1. Card Visuals with Conditional Formatting
- Convert key fields into card visuals with icons and color coding
- Use status indicators (green/yellow/red) for priority levels or stages
2. HTML Content/Table Visual
- Use the "HTML Content" custom visual to create styled, formatted content with colors, badges, and icons
- Add visual hierarchy with font sizes and weights
3. Chiclet Slicer for Categories
- Replace dropdown filters with image-based chiclet slicers showing product categories or regions with icons
4. Timeline Slicer
- If you have date fields, use a timeline slicer for intuitive date range selection
5. Hierarchy Slicer or Tree Visual
- For nested categories (Product Category → Sub-category), use a tree/hierarchy visualization
6. Card Grid Layout
- Break the single table into multiple smaller card-style containers grouped by category
- Add subtle borders, shadows, and spacing
7. Custom Visuals to Consider
- Synoptic Panel: Create image-based clickable regions
- Text Filter: Advanced search functionality
- Infographic Designer: Add icons and visual elements
Best regards!
PS: If you find this post helpful consider leaving kudos or mark it as solution
Thanks for your feedback. Sharing the github link to the file for your reference - priyam2790/PBI (Sample Dashboard file) rohit1991 Mauro89