Jeroen Scholten

✨ 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

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.077

23 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

𝐍𝐞𝐰 𝐕𝐢𝐝𝐞𝐨 𝐀𝐥𝐞𝐫𝐭 𝐨𝐧 𝐁𝐡𝐚𝐫𝐚𝐭𝐡 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬 🎥 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

🤯 The New Card Visual in Power BI: Aka who asked for a thousand formatting options? Because that’s exactly what we got. Every time I try to format a KPI card it feels like: Change the Callout Value → suddenly Reference Labels are gone Wanna add context → surprise, you need a Reference Label plus 1000 settings 🙃 Wanna conditionally format the background of the Value → nope, you’ll need a detail first, because background fx isn’t available there 🤦‍♀️ I could go on like this for hours… So many parts, no clear map, and at some point you’re just praying the KPI will magically look right. Because you are super tired on non stop clicking. Sure, you could bypass it… but KPI Cards without context are pretty useless. So here we are, suffering together. That’s why I broke it down into the DNA of a KPI Card – the stuff that actually matters: 👉 Title (what it is) 👉 Callout Value (the number you want to communicate) 👉 Reference Label (the context) 👉 Details (more context but with conditionally formatted background) 👉 Image (At least this works most of the time :D ; can also be an SVG) 👉 Background/ Border/ Shape With this map, at least you know which setting you’re fighting with. ⚡ Pro tip: Think Twice which Callout Value you need, as all the reference values are gone if you have to change it. And you start the desparte formatting journey again... 👀 Anyone else feeling really desparate each time the New Card Visual is needed? What’s your biggest formatting nightmare?

299

21 commentaren