SSBI Central
SSBI Central
  • 60
  • 30 258
Dynamic format strings and conditional formatting in Power BI | Antony Catella
Speaker: Antony Catella
Recording Date: Thu, Sep 19th 2024
Language: ENGLIGH
Session files: github.com/cristiangyal/ROPUG_Files
==========================================================
Description:
In general formatting of visuals in a Power BI report are fixed for the end user. How can we give end users more flexibility to format the visuals for their requirements?
In this presentation, we look at making use of dynamic format strings and conditional formatting in Power BI, to allow dynamic formatting of visuals. We begin with an overview of the basic concepts of dynamic format strings, which allow for the customization of displayed data based on context and user interactions. Attendees will learn how to apply these strings to enhance the readability of data visuals.
Moving onto the intricacies of conditional formatting and demonstrating how to use rules and expressions to highlight data points within visuals. We also demo combining dynamic format strings with conditional formatting to give end users significant flexibility in what to display in visuals.
By the end of this presentation, participants will have a comprehensive understanding of how to leverage these features to transform their Power BI reports into dynamic, insightful, and visually appealing tools for data analysis.
===============================================================
At the end of the Meetup we had a Raffle with prizes offered by Enterprise DNA: 2 (two) 1 year FREE Membership Licenses on EDNA Platform for two lucky winners from the Live attendees !
==========================================================
Speaker: Antony Catella
Senior BI Consultant
Antony is a BI Consultant @ Adroit Data & Insight Consultancy, UK, working primarily with Non-Profits to develop Power BI reports for them and provide Power BI training for their staff.
I am passionate about the natural world and enjoy mountain biking and baking in my spare time.
Connect with Antony here:
LinkedIn: www.linkedin.com/in/antonycatella/
มุมมอง: 117

วีดีโอ

Join RomanianDATA Tribe | Sergiu Rotaru and Claudiu Anghelescu
มุมมอง 244 ชั่วโมงที่ผ่านมา
Speakers: SERGIU ROTARU and CLAUDIU ANGHELESCU Recording Date: Thu, Sep 12th 2024 Language: ROMANIAN ⚠️ Description: Discover the community/tribe that wants to improve the data visualization literacy in Romania through monthly challenges. At the end of the Meetup we had have a Raffle with prizes offered by ETA2U: 1 FREE Voucher for a Data Related Training Live with ETA2U for one lucky winner fr...
From Imagination to Reality: Craft Any KPI in PowerBI with Powerviz KPI Visual | Lakshmi Ponnurasan
มุมมอง 644 ชั่วโมงที่ผ่านมา
Speaker: Santhana Lakshmi Ponnurasan Recording Date: Thu, Aug 29th 2024 Language: ENGLISH Description: Join me for a fun and interactive session where we'll dive into the incredible world of the KPI Visual, a custom Power BI visual by Powerviz that can turn any KPI idea you have into a stunning, functional visual. Whether you want to track performance, measure success, or visualize trends, the ...
Why and How to Consider Design When Crafting a Dashboard | Diana Maier
มุมมอง 144หลายเดือนก่อน
Speaker: DIANA MAIER Recording Date: Thu, Aug 8th 2024 Language: ROMANIAN ⚠️ Session Slides: github.com/cristiangyal/ROPUG_Files Discover why thoughtful design is essential for creating effective dashboards that enhance user experience, improve comprehension, and increase engagement. We’ll explore key design principles and practical tips to help both designers and data professionals elevate the...
Adding custom totals to your tables with Calculation Groups | Bernat Agulló
มุมมอง 209หลายเดือนก่อน
Speaker: Bernat Agulló Recording Date: Thu, Jul 25th 2024 Language: ENGLIGH Description: Sometimes we might get the following request: I want to see the sales by month and at the end I want to see the total for the year, but also the average sales per month, the sales from previous year and the absolute and percentual change vs previous year. This is not straight forward in Power BI but Calcula...
Power BI Best Practices (Part 1) | Denis FĂRÎMĂ
มุมมอง 1732 หลายเดือนก่อน
Speaker: DENIS FĂRÎMĂ Recording Date: Wed, Jul 10th 2024 Language: ROMANIAN ⚠️ Session_Files: github.com/cristiangyal/ROPUG_Files Description: In this session we will discuss how to build maintainable and scalable solutions with Microsoft PowerBI. At the end of the Meetup we had have a Raffle with prizes offered by ETA2U: 1 FREE Voucher for a Data Related Training Live with ETA2U for one lucky ...
The Excel and Power BI user's guide to ChatGPT | Wyn Hopkins
มุมมอง 2932 หลายเดือนก่อน
Speaker: Wyn Hopkins Recording Date: Thu, Jun 27th 2024 Language: ENGLISH Description: How can Chat GPT help you create better reports quicker? Wyn has created a number of GPTs that are available from the Chat GPT store including a Power Query Magician, A DAX helper, a Visualization expert and and Excel formula helper. Wyn will talk you through how they were created and demonstrate how they hel...
Oncoming features for Core Visuals in Power BI | Miguel Myers
มุมมอง 1K2 หลายเดือนก่อน
Speaker: Miguel Myers Recording Date: Thu, May 30th 2024 Language: ENGLIGH Description: Join Miguel Myers, a visionary in the Power BI landscape, as he unveils the roadmap to revolutionary features set to transform your data experience. In this exclusive session, Miguel will share a first glimpse into the innovative capabilities our team is crafting for the months ahead. Seize this rare chance ...
Top 3 life changing reports in Excel | Mihaela Stancu
มุมมอง 2063 หลายเดือนก่อน
Speaker: Mihaela Stancu Recording Date: Thu, Jun 13th 2024 Language: ROMANIAN ⚠️ Session working files: github.com/cristiangyal/ROPUG_Files Description: When you have lots of data coming your way, you might find it impossible to approach just the one you actually need, in order to work more efficiently. But wait, this is not the complete story: once you get the right data, how can you make sure...
Power Up Your Data: Synergizing Power BI & Power Apps | Cristian Prifti
มุมมอง 994 หลายเดือนก่อน
Speaker: Cristian Prifti Recording Date: Thu, May 9th 2024 Language: ROMANIAN ⚠️ Description: 🌟 Empower Your Apps and Analytics: Integrating Power BI with Power Apps 🌟 Join us for an electrifying session where we explore the dual power of Power BI and Power Apps! Learn how to not only embed detailed Power BI dashboards into Power Apps for dynamic data insights but also enhance Power BI reports ...
Rele practici în Excel și cum să le evităm| Romulus Milea
มุมมอง 2154 หลายเดือนก่อน
Speaker: Romulus Milea Recording Date: Wed, Apr 24th 2024 Language: ROMANIAN File for practice here: github.com/cristiangyal/ROPUG_Files Description: Destul de mulți utilizatori Excel practică fără să își dea seama diverse stiluri de lucru care mai devreme sau mai târziu își vor arăta dezavantajele. Dacă găsim peste tot cursuri și sfaturi despre bunele practici, de data aceasta încercăm să scoa...
Visual Calculations - Making DAX easier | Jeroen (Jay) ter Heerdt
มุมมอง 1935 หลายเดือนก่อน
Speaker: Jeroen (Jay) ter Heerdt Recording Date: Thu, Apr 11th 2024 Language: ENGLIGH Description: This is it. The day that the way that DAX became easier. After this, how you write DAX changes forever. Learn all about it in this session! The Power BI team has been working on exciting things related to DAX calculations, specifically targeted at making it easier to add typical business-type calc...
Understanding the External Tools ecosystem: Tabular Editor | Daniel Otykier
มุมมอง 1115 หลายเดือนก่อน
Speaker: Daniel Otykier Recording Date: Wed, Nov 29th 2023 Language: ENGLIGH Description: If you’re a Power BI developer you’ve probably heard about External Tools, and you may already be using a few of them in your daily work. In this session, we’ll provide a brief overview of the most popular tools available today, before diving deeply into one of them; Tabular Editor - a free, open-source to...
Data Visualization Techniques for Effective Dashboard Creation | Gustaw Dudek
มุมมอง 4.5K5 หลายเดือนก่อน
Speaker: Gustaw Dudek Recording Date: Thu, Mar 28th 2024 Language: ENGLIGH 📁 Files will be available here starting Apr 3rd 2024: github.com/cristiangyal/ROPUG_Files Description: During the presentation, we will discuss a range of techniques to focus on while developing reports. We will touch upon selected principles from the IBCS, using practical possibilities for their implementation in Power ...
Power BI Dataset & Power Automate Magic | Cristian Prifti
มุมมอง 2095 หลายเดือนก่อน
Speaker: Cristian Prifti Recording Date: Thu, Nov 16th 2023 Language: ROMANIAN Description: Overall the Power platform provides an amazing integration, but particularly in this showcase, we will look into how to use the Power BI dataset, run DAX queries against it, so that we further use the data for customized notifications or alerts. At the end of the Meetup we had a have a Raffle with prizes...
Power Up Your Excel: Unlocking the Magic of Power Pivot | Cristian Angyal
มุมมอง 3685 หลายเดือนก่อน
Power Up Your Excel: Unlocking the Magic of Power Pivot | Cristian Angyal
Webinar OnLearn - De la Excel la Power BI | Radu Popa & Cristian Angyal
มุมมอง 1015 หลายเดือนก่อน
Webinar OnLearn - De la Excel la Power BI | Radu Popa & Cristian Angyal
3 Things Every Power Query User Should Know | Gašper Kamenšek
มุมมอง 6465 หลายเดือนก่อน
3 Things Every Power Query User Should Know | Gašper Kamenšek
Data summaries in Excel: Pivot and Power Pivot | Radu Popa
มุมมอง 1896 หลายเดือนก่อน
Data summaries in Excel: Pivot and Power Pivot | Radu Popa
Power BI la Următorul Nivel: Magia Automatizării cu PowerShell | Ioana Bouariu
มุมมอง 1366 หลายเดือนก่อน
Power BI la Următorul Nivel: Magia Automatizării cu PowerShell | Ioana Bouariu
Microsoft Fabric's Gen 2 Dataflow - Where Even Data Gets a Standing Ovation | Parv Chana
มุมมอง 746 หลายเดือนก่อน
Microsoft Fabric's Gen 2 Dataflow - Where Even Data Gets a Standing Ovation | Parv Chana
Tips and Tricks in Modern Excel | Gabriel Cheva
มุมมอง 2097 หลายเดือนก่อน
Tips and Tricks in Modern Excel | Gabriel Cheva
Firul magic al narativității: Cum storytelling transformă designul | Alex Badiu
มุมมอง 1478 หลายเดือนก่อน
Firul magic al narativității: Cum storytelling transformă designul | Alex Badiu
Leveraging Field Parameters for Dynamic Data Visualization | Antony Catella
มุมมอง 2978 หลายเดือนก่อน
Leveraging Field Parameters for Dynamic Data Visualization | Antony Catella
Let's improve the Tabular Model by combining queries | Ana Maria Bisbe York
มุมมอง 16811 หลายเดือนก่อน
Let's improve the Tabular Model by combining queries | Ana Maria Bisbe York
Smart work with Dynamic Arrays in Excel | Victor Momoh
มุมมอง 38211 หลายเดือนก่อน
Smart work with Dynamic Arrays in Excel | Victor Momoh
Advanced Power Query for Business Analysis | Viorel Cazacu
มุมมอง 407ปีที่แล้ว
Advanced Power Query for Business Analysis | Viorel Cazacu
Analytics Godzilla - Combining Power BI, R, and ChatGPT Code Interpreter | Brian Julius
มุมมอง 674ปีที่แล้ว
Analytics Godzilla - Combining Power BI, R, and ChatGPT Code Interpreter | Brian Julius
Strategii si principii de rezolvare a problemelor complexe in Excel | Valy Greavu
มุมมอง 227ปีที่แล้ว
Strategii si principii de rezolvare a problemelor complexe in Excel | Valy Greavu
Introducing the "Measure Killer" for Power BI | Gregor Brunner, Klaus Folz
มุมมอง 272ปีที่แล้ว
Introducing the "Measure Killer" for Power BI | Gregor Brunner, Klaus Folz