Visualization Customization Options

𝗥𝗲𝗱𝗲𝗳𝗶𝗻𝗶𝗻𝗴 𝗟𝗲𝗴𝗲𝗻𝗱𝘀 𝗶𝗻 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜: 𝗨𝘀𝗶𝗻𝗴 𝗕𝗔𝗦𝗘64 𝗜𝗺𝗮𝗴𝗲𝘀 𝗳𝗼𝗿 𝗖𝘂𝘀𝘁𝗼𝗺 𝗩𝗶𝘀𝘂𝗮𝗹𝘀 Power BI’s default legends are functional, but not always flexible. They take up space, limit design options, and don’t always match the look you want. A simple way to take control is by using 𝗕𝗔𝗦𝗘64 𝗶𝗺𝗮𝗴𝗲𝘀 inside custom visuals. This lets you design your own legend system with icons, logos, or stylised shapes - all within Power BI. ✅ Why it’s worth trying: • 𝗗𝗲𝘀𝗶𝗴𝗻 𝗳𝗹𝗲𝘅𝗶𝗯𝗶𝗹𝗶𝘁𝘆 → swap plain text for icons or branded graphics • 𝗦𝗽𝗮𝗰𝗲 𝗼𝗽𝘁𝗶𝗺𝗶𝘀𝗮𝘁𝗶𝗼𝗻 → cleaner, inline indicators instead of bulky legends • 𝗖𝗼𝗻𝘀𝗶𝘀𝘁𝗲𝗻𝗰𝘆 → align with brand guidelines or client design systems • 𝗨𝘀𝗲𝗿 𝗲𝘅𝗽𝗲𝗿𝗶𝗲𝗻𝗰𝗲 → faster to scan and interpret at a glance ⚙️ How to set it up: 1. Create or source your icons (PNG → BASE64 conversion works well). 2. Convert them into BASE64 strings. 3. Store those strings in a table (e.g. LegendIcons). 4. Set the column’s Data Category to “Image URL” so Power BI renders the BASE64 as an image. 5. Bind the column to an Image custom visual. 6. Place the icons wherever you need them - legends, headers, KPI cards, or even table rows. This approach lets you 𝗱𝗶𝘁𝗰𝗵 𝗿𝗶𝗴𝗶𝗱 𝗱𝗲𝗳𝗮𝘂𝗹𝘁𝘀 and treat your report more like a designed application. Small tweaks like this can transform how polished and usable your dashboards feel. #PowerBI #UIUX #DataViz

#PowerBI has introduced new 𝐕𝐢𝐬𝐮𝐚𝐥 𝐋𝐞𝐯𝐞𝐥 𝐅𝐨𝐫𝐦𝐚𝐭 𝐒𝐭𝐫𝐢𝐧𝐠𝐬 (𝐩𝐫𝐞𝐯𝐢𝐞𝐰), offering more flexibility in formatting data🎉🎉 Originally designed to address the formatting limitations of #visual_calculations, which aren't part of the data model, this feature allows us to format calculations directly within visuals. With this update, Power BI now supports three hierarchical levels of format strings: 𝟏) 𝐌𝐨𝐝𝐞𝐥 𝐋𝐞𝐯𝐞𝐥: Applies to columns and measures 𝐚𝐜𝐫𝐨𝐬𝐬 𝐚𝐥𝐥 𝐯𝐢𝐬𝐮𝐚𝐥s unless overridden. 𝟐) 𝐕𝐢𝐬𝐮𝐚𝐥 𝐋𝐞𝐯𝐞𝐥: 𝐍𝐞𝐰𝐥𝐲 𝐢𝐧𝐭𝐫𝐨𝐝𝐮𝐜𝐞𝐝 with the August 2024 version, it allows formatting for any column, measure, or visual calculation within a specific visual, 𝐨𝐯𝐞𝐫𝐫𝐢𝐝𝐢𝐧𝐠 𝐦𝐨𝐝𝐞𝐥-𝐥𝐞𝐯𝐞𝐥 𝐬𝐞𝐭𝐭𝐢𝐧𝐠𝐬. 𝟑) 𝐄𝐥𝐞𝐦𝐞𝐧𝐭 𝐋𝐞𝐯𝐞𝐥: Used for specific visual elements like 𝐝𝐚𝐭𝐚 𝐥𝐚𝐛𝐞𝐥𝐬, 𝐨𝐯𝐞𝐫𝐫𝐢𝐝𝐢𝐧𝐠 𝐛𝐨𝐭𝐡 𝐦𝐨𝐝𝐞𝐥 𝐚𝐧𝐝 𝐯𝐢𝐬𝐮𝐚𝐥 𝐥𝐞𝐯𝐞𝐥𝐬. 📊 For example, we can format a measure as a whole number on one visual while keeping it as a decimal in the model, or apply scientific notation only to data labels. This hierarchy ensures that the most specific formatting settings are applied, offering greater control and customization. #PowerBI #DataVisualization #BusinessIntelligence #DataAnalysis

📊 Enhancing Power BI Reports with Custom Visuals 🚀 Unlock the full potential of your Power BI reports by incorporating custom visuals! Here are key considerations for a successful integration: Data Compatibility: Ensure your chosen custom visual aligns with your data source, handling data types effectively. Reliability and Support: Opt for well-maintained visuals with active support to avoid issues down the line. Performance: Test the visual's performance with your data to prevent slowdowns in report rendering. Accessibility: Prioritize visuals that adhere to accessibility standards for an inclusive user experience. Data Security: Confirm compliance with your organization's data security policies to safeguard sensitive information. License and Cost: Be mindful of any licensing costs associated with custom visuals, as they can add up. User Training: Provide training or documentation for users to navigate custom visuals effectively. Customization Options: Ensure visuals can be tailored to match your report's branding and requirements. Integration: Verify seamless integration with Power BI features like filters and cross-filtering. Compatibility with Updates: Keep visuals up to date with Power BI's latest versions for smooth operation. Community and Documentation: Leverage user communities and documentation for troubleshooting and best practices. Vendor Reputation: Trust reputable vendors for reliable and well-maintained custom visuals. Scalability: Confirm that visuals scale efficiently as your reports and datasets grow. Legal Compliance: Ensure compliance with legal regulations and licensing agreements. User Feedback: Continuously gather user feedback to refine and optimize custom visuals. #PowerBI

This month’s Power BI update is quite exciting... 🤓 The PBI Core Visuals team is working on some pretty cool stuff lately. Let’s dive into the details. 1️⃣ Marker Enhancements: Advanced controls for markers make data points pop: ↳ Customize by Categories or Series: Control marker styles at the category or series level. ↳ Marker Visibility Toggles: Toggle markers on/off for specific categories or series. ↳ Marker Shape & Transparency Control: Personalize markers by adjusting shapes (rotations supported, except circles) and sizes. ↳ Customizable Marker Borders: adjustable color, transparency, and width. 2️⃣ Small Multiples for Card Visuals: Compare data across categories or dimensions with ease: ↳ Flexible Layout Options: Choose Single Column, Single Row, or Grid layouts. ↳ Overflow Handling: Use pagination or continuous scrolling to manage excess data. ↳ Advanced Styling Controls: Customize borders, gridlines, and background colors. Round corners for a modern look. ↳ Header & Title Customization: Control header settings and adjust titles for font, color, padding, and text wrap. Align with your report’s branding. 3️⃣ New Text Slicer: Enhance data filtering with text-based searches: ↳ Intuitive Text Filtering: Type into the input box to filter data in real-time. ↳ Comprehensive Appearance Customization: Configure the input box with placeholder text, font, color, and transparency. ↳ Enhanced Button Controls: Adjust Apply button settings for color, transparency, borders, and padding. Customize the Dismiss button for clearing filters. ↳ Focus Accent Bar & Borders: Highlight the active input field with an accent bar. Set borders around the input area. Excited about these new features? I for sure am 🚀 * Note 1: Some features might still be in development. * Note 2: All images used are from Microsoft as unfortunately I don't have the latest version of Power BI on my laptop yet * Note 3: Links to all the updates details in the comments! #data #datapears #powerbi #report #reporting #dataviz #datavisualization #news

Deneb and Vega-Lite can be used to create custom gauge visuals in Power BI. This exercise explores 4 different options (2 linear gauges and 2 circular gauges), each of which display the percentage in a different manner. As well, the 2nd and 4th visuals display data-driven colour ranges. These examples illustrate a number of Deneb/Vega-Lite features, including: 1-Linear Gauge (gradient): - use of three overlapping (layered) marks (2x bar [background & foreground] and 1x text [data value]) - use of rounded corners on the bar marks - use of transparent-to-blue gradient colours for the foreground bar 2-Linear Gauge (scale): - use of four overlapping (layered) marks (bar, text [range], point [inverted triangle symbol], text [data value]) - use of a "transform" block to extend the dataset with in-visual calculations of the range mid points - use of data values for the range colours - use of black border and white fill for the "pointer" symbol 3-Circular Gauge (radial): - use of a "transform" block to extend the dataset with in-visual calculations of the start-and-end degrees and radians for the background and foreground arc marks - use of a "params" block to enhance the visual with configuration settings and calculations for arc position and size - use of three overlapping (layered) marks (2x bar [background & foreground] and 1x text [data value]) - use of transparent-to-blue gradient colours for the foreground bar 4-Circular Gauge (speedometer): - use of a "transform" block to extend the dataset with in-visual calculations of the start-and-end degrees and radians for the scale size and needle position - use of a "params" block to enhance the visual with configuration settings and calculations for scale position and size - use of five overlapping (layered) marks (2x arc [background & scale], 1x point [pointer; shape=wedge], 1x circle [black border and white fill], and 1x text [data value]) - use of data values for the scale sizes and colours The intent of this example was not to provide a finished visual, but rather to investigate the possibilities offered by the use of the Vega-Lite language and the Deneb custom visual within Power BI. For those interested in more details about the example and/or the sample PBIX used, refer to the post in the Deneb Showcase section of the Enterprise DNA Support Forum: https://lnkd.in/e8GkvDqR #Deneb #VegaLite #EnterpriseDNA