Lauran van Hoek

How to improve your KPI Cards in Power BI? New video is out on Youtube. It is about a KPI Card makeover, turning a messy layout into something cleaner. Link in the comments.

1.078

24 commentaren

𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗜𝗻𝘁𝗲𝗿𝗮𝗰𝘁𝗶𝘃𝗲 𝗟𝗲𝗴𝗲𝗻𝗱 – 𝗗𝗼𝘄𝗻𝗹𝗼𝗮𝗱 𝗔𝘃𝗮𝗶𝗹𝗮𝗯𝗹𝗲! I’ve created a video showing two approaches for building an interactive legend in Power BI. One uses a custom visual, the other only standard visuals. Can you guess which is which? A while back, I built this concept using a custom visual. But if you know me, you know I don't recommend using custom visuals - unless they're from well-established players like Lumel or Zebra BI. 𝗪𝗵𝘆? • 𝗠𝗮𝗶𝗻𝘁𝗲𝗻𝗮𝗻𝗰𝗲 𝗿𝗶𝘀𝗸𝘀: Smaller developers may not keep their visuals updated for new Power BI features or bug fixes. • 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲 𝗶𝘀𝘀𝘂𝗲𝘀: Custom visuals can slow down your reports, especially with large datasets. • 𝗟𝗶𝗺𝗶𝘁𝗲𝗱 𝘀𝘂𝗽𝗽𝗼𝗿𝘁: If something breaks, you're often left without timely help or documentation. That’s why I revisited this concept and built an alternative using only standard Power BI visuals - no custom visuals required. 📂 𝗜𝗻 𝘁𝗵𝗲 𝗱𝗼𝘄𝗻𝗹𝗼𝗮𝗱, 𝘆𝗼𝘂’𝗹𝗹 𝗳𝗶𝗻𝗱: • The two PBIX files (custom visual and standard visual solutions) • The dataset needed • The icons used Link: https://lnkd.in/eTzT39qZ Watch the video, try both approaches, and let me know which one you prefer! #PowerBI #UIUX #DataViz

479

28 commentaren

✨ Card Browser in Power BI You don’t need a custom visual to create a clean client, product, people catalogue ✅🙌 Step 1: Configure the Visual Select the Card (new) visual. In the visual settings, enable the Multi-Category layout. This arranges the cards in grouped sections based on max rows shown. Step 2: Headers and Formatting Enable Category Headers and adjust font, alignment, and spacing. Step 3: Add an Image per Card Combine a card visual with a dynamic image element (e.g., image URL from the dataset). Place them together inside a grid layout. Step 4: Add Slicers to Make it Searchable Place slicers (e.g. by category, status, or owner) above the visuals. See full video to do it step by step. #powerbi #report #card #kpi #visual #analytics

229

6 commentaren

🚀 𝐍𝐞𝐰 𝐑𝐞𝐟𝐫𝐞𝐬𝐡 𝐎𝐩𝐭𝐢𝐨𝐧𝐬 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐃𝐞𝐬𝐤𝐭𝐨𝐩! Power BI Desktop now gives us more flexibility when refreshing: ✅Schema + Data ✅Schema only ✅Data only 👉 By default, a refresh always included a schema sync first, followed by the data refresh. 👉 Now, you can choose to refresh only the data without updating the schema. This is super handy in scenarios where, for example, a new column was added in the source but you don’t want to bring it into your model yet, you just want the latest data. A small change, but a big improvement in flexibility and efficiency for Power BI developers! 💡 thanks Sandeep Pawar for sharing #powerbi #dax #semantic_model #Microsoft_fabric

263

15 commentaren

⚡ Not all measures in Power BI are created equal! If you’re still relying on implicit measures, you’re limiting your reports without even realizing it. Here’s the truth: ▪️ Implicit measures are quick, but not reusable. ▪️ Explicit measures give you flexibility, consistency, and scalability. That’s why professionals always go explicit over implicit. 👉 Swipe through this guide to learn why explicit > implicit in Power BI. 💡 Which one do you use more often in your reports - implicit or explicit? Follow Debabrata Palit for more insights!! 🤝 #PowerBI #DataAnalytics #BusinessIntelligence #DAX #Measures

132

37 commentaren

🔍 I got it wrong... and I'm excited to share what I learned! A few months back, I dove deep into Custom Comparer functions for Power Query's Table.Group. Pretty advanced stuff with some niche applications. Plot twist: After sharing my theory, the M community jumped in with fresh examples. That's when I realized... I had misunderstood how this functionality actually works! 😅 The good news? Thanks to examples from Zoran, Aditya, and other Power Query wizards, I've completely revised my understanding. ✅ The updated article is now live on my website (link in comments) Here's what found: You can group ALL consecutive dates together using just a single Table.Group formula with a custom comparer. 🎯 Visual example: Start with: Base Table (scattered dates) End with: Grouped Table (consecutive dates perfectly organized) Question for you, have you ever used custom comparer functions in Table.Group? What creative solutions have you built? #PowerQuery #Excel #PowerBI

153

13 commentaren

Earlier this week I shared my thoughts about the 'Future of Work' (https://lnkd.in/ejRfJYcT) and how MCP support in LLMs can change the way Power BI Developers work. Here is sneak peek of that future. ⸻ #PowerBI #FutureOfWork #DAX #MicrosoftFabric #ModelContextProtocol

42

1 commentaar

𝐍𝐞𝐰 𝐕𝐢𝐝𝐞𝐨 𝐀𝐥𝐞𝐫𝐭 𝐨𝐧 𝐁𝐡𝐚𝐫𝐚𝐭𝐡 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬 🎥 Have you ever jumped straight into building a Power BI dashboard… …and later realized the layout looks messy or doesn’t meet user needs? That’s where 𝐃𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝 𝐖𝐢𝐫𝐞𝐟𝐫𝐚𝐦𝐢𝐧𝐠 comes in! In my latest video, I explain: ✅ What Power BI Dashboard Wireframing is ✅ Types of wireframing approaches (low, medium & high fidelity) ✅ Why wireframing is a game-changer for clean, impactful dashboards 💡 Think of it like sketching a house before construction ,wireframing helps you save time, reduce rework, and deliver dashboards that truly tell a story. 📺 Watch the full video here 👉 https://lnkd.in/gVQ3gQVH If you’re into 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈, 𝐝𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝 𝐝𝐞𝐬𝐢𝐠𝐧, 𝐨𝐫 𝐝𝐚𝐭𝐚 𝐬𝐭𝐨𝐫𝐲𝐭𝐞𝐥𝐥𝐢𝐧𝐠 this one’s for you! Let me know your thoughts in the comments 👇 #PowerBI #DashboardDesign #Wireframing #BharathInsights #DataAnalytics

61

3 commentaren

This month, we celebrate 10 years since the launch of Microsoft Power BI, a tool that has become one of the most widely adopted BI platforms in the world today along with Tableau. What’s behind it's success in a market with so many BI platforms? It’s more than just visuals. Over the past decade, Power BI has become the go-to platform for analysts and decision-makers because it does more than build dashboards—it enables end-to-end analytics: → Seamless data connectivity across flat files, SQL databases, APIs, and web sources → Powerful Power Query transformations to clean and reshape data intuitively → Robust data modeling features including relationship design, DAX measures, and calculated columns → Rich and interactive visualizations like decomposition trees, KPI gauges, custom visuals, and slicers → Enterprise-ready publishing, dashboard sharing, and real-time collaboration → Integration with Excel, Azure, and Microsoft Teams—making it fit naturally into many business environments It has also empowered a generation of data professionals to become BI creators, not just consumers, thanks to the accessibility and scalability it offers, from individual analysts to enterprise-level deployments. Whether you're just getting started or deep into DAX optimizations and row-level security, there’s something in Power BI for every stage of your analytics journey. As someone who’s explored everything from data modeling and transformation to DAX calculations and dashboard design, I’ve seen firsthand why Power BI has become such a game-changer. And if you're just starting your journey, here's a quick look at what the Power BI learning curve might cover: ‣ BI Concepts & Architecture ‣ Connecting to CSV, SQL, Web Sources ‣ Power Query & ETL ‣ Data Modeling & Relationships ‣ DAX (Measures, Columns, Tables) ‣ Report Design & Visual Interactions ‣ Dashboard Publishing & Sharing Here’s to a decade of data-driven decisions, powered by Power BI. If you wish to get started on Power BI or need a refresher, here's a guide to help you with the basics all the way to its key advanced functionalities #PowerBI #DataAnalytics #BusinessIntelligence #MicrosoftBItools #DataVisualization #10YearsOfPowerBI #DataProfessionals

94

4 commentaren