Andrzej Leszkiewicz
@avatorl.bsky.social
Power BI Developer and Consultant
Data Explorer, Visualizer, Explainer
IBCS® Certified Analyst
Data Explorer, Visualizer, Explainer
IBCS® Certified Analyst
www.powerofbi.org/2025/09/16/n... DAX user-defined functions!
New DAX! User-Defined Functions - Power of Business Intelligence
Now you can create your own DAX functions, reuse them in your reports, and share them with the community. Power BI Desktop: File | Options … Read More
www.powerofbi.org
September 15, 2025 at 11:26 PM
www.powerofbi.org/2025/09/16/n... DAX user-defined functions!
A report user doesn't understand non-additive calculations, so you change the measure total to be additive, disregarding the statistical and business meaning.
The last step on this slippery road is saying, without a gram of sarcasm, "Mr. Trump, you're the most stable genius in the universe".
The last step on this slippery road is saying, without a gram of sarcasm, "Mr. Trump, you're the most stable genius in the universe".
August 28, 2025 at 7:59 AM
A report user doesn't understand non-additive calculations, so you change the measure total to be additive, disregarding the statistical and business meaning.
The last step on this slippery road is saying, without a gram of sarcasm, "Mr. Trump, you're the most stable genius in the universe".
The last step on this slippery road is saying, without a gram of sarcasm, "Mr. Trump, you're the most stable genius in the universe".
Power BI embedded report with Row Level Security on my website: www.powerofbi.org/power-bi-emb...
Power BI Embedded Demo - Power of Business Intelligence
All other reports on my website use Publish to Web (unsecure way to publish public open-data and dummy-data reports). This one is a truly securely … Read More
www.powerofbi.org
August 9, 2025 at 10:00 PM
Power BI embedded report with Row Level Security on my website: www.powerofbi.org/power-bi-emb...
Fabric Deployment Pipeline Rule to set Data Pipeline Parameter + Deployment Stage Conditional Formatting in Power BI Reports
Change notebook parameters by deployment rules and format your reports differently for different deployment stages.
www.powerofbi.org/2025/08/09/f...
#PowerBI #Fabric
Change notebook parameters by deployment rules and format your reports differently for different deployment stages.
www.powerofbi.org/2025/08/09/f...
#PowerBI #Fabric
Fabric Deployment Pipeline Rule to set Data Pipeline Parameters - Power of Business Intelligence
I probably should give the Fabric Variable libraries (preview) a try. But a preview is essentially a beta version, and if a workaround based on … Read More
www.powerofbi.org
August 9, 2025 at 9:12 AM
Fabric Deployment Pipeline Rule to set Data Pipeline Parameter + Deployment Stage Conditional Formatting in Power BI Reports
Change notebook parameters by deployment rules and format your reports differently for different deployment stages.
www.powerofbi.org/2025/08/09/f...
#PowerBI #Fabric
Change notebook parameters by deployment rules and format your reports differently for different deployment stages.
www.powerofbi.org/2025/08/09/f...
#PowerBI #Fabric
War statistics are only stunning if you forget history
June 29, 2025 at 5:00 PM
War statistics are only stunning if you forget history
I don't often join Workout Wednesday, but when I do, I prefer unconventional solutions.
Ladies and gentlemen, let me present the Button Slicer Box Plot!
www.powerofbi.org/2025/06/11/w...
#WOW2025 #PowerBI @dm-p.nz @mmarie.bsky.social @merrykerry.bsky.social @shan-gsd.bsky.social
Ladies and gentlemen, let me present the Button Slicer Box Plot!
www.powerofbi.org/2025/06/11/w...
#WOW2025 #PowerBI @dm-p.nz @mmarie.bsky.social @merrykerry.bsky.social @shan-gsd.bsky.social
WoW 2025 Week 24 | Power BI Core Slicers Box Plot - Power of Business Intelligence
I don’t often join Workout Wednesday, but when I do, I prefer unconventional solutions. This week, WoW is about PBI Core Visuals, but slicers are … Read More
www.powerofbi.org
June 11, 2025 at 9:20 PM
I don't often join Workout Wednesday, but when I do, I prefer unconventional solutions.
Ladies and gentlemen, let me present the Button Slicer Box Plot!
www.powerofbi.org/2025/06/11/w...
#WOW2025 #PowerBI @dm-p.nz @mmarie.bsky.social @merrykerry.bsky.social @shan-gsd.bsky.social
Ladies and gentlemen, let me present the Button Slicer Box Plot!
www.powerofbi.org/2025/06/11/w...
#WOW2025 #PowerBI @dm-p.nz @mmarie.bsky.social @merrykerry.bsky.social @shan-gsd.bsky.social
I proposed the trolley problem to ChatGPT: a cockroach vs. Putin. It chose to kill Putin and explained why. Smart enough. The Turing test passed.
June 9, 2025 at 9:50 PM
I proposed the trolley problem to ChatGPT: a cockroach vs. Putin. It chose to kill Putin and explained why. Smart enough. The Turing test passed.
One more experiment with the Button Slicer: Row-Level Security (RLS)-based default slicer selection (for cases where security isn't required, but a default selection is desired).
The logged-in employee is selected by default and highlighted in red font.
www.powerofbi.org/2025/06/07/r...
The logged-in employee is selected by default and highlighted in red font.
www.powerofbi.org/2025/06/07/r...
Row Level Security → Default Slicer Selection - Power of Business Intelligence
One more experiment with the Button Slicer: Row-Level Security (RLS)-based default slicer selection (for cases where security isn’t required but a default selection is desired). … Read More
www.powerofbi.org
June 7, 2025 at 8:47 AM
One more experiment with the Button Slicer: Row-Level Security (RLS)-based default slicer selection (for cases where security isn't required, but a default selection is desired).
The logged-in employee is selected by default and highlighted in red font.
www.powerofbi.org/2025/06/07/r...
The logged-in employee is selected by default and highlighted in red font.
www.powerofbi.org/2025/06/07/r...
Magic of the new Power BI Button Slicer: the current calendar month is always selected by default.
In the video, I change the system date, refresh the report, and the slicer selection updates automatically to reflect the new current month.
Link to the instructions and PBIX file in a comment.
In the video, I change the system date, refresh the report, and the slicer selection updates automatically to reflect the new current month.
Link to the instructions and PBIX file in a comment.
June 6, 2025 at 6:58 AM
Magic of the new Power BI Button Slicer: the current calendar month is always selected by default.
In the video, I change the system date, refresh the report, and the slicer selection updates automatically to reflect the new current month.
Link to the instructions and PBIX file in a comment.
In the video, I change the system date, refresh the report, and the slicer selection updates automatically to reflect the new current month.
Link to the instructions and PBIX file in a comment.
I've just installed the latest Power BI Desktop.
June 4, 2025 at 8:49 AM
I've just installed the latest Power BI Desktop.
This is how you create a (white) hole in a map. I think it looks like a bar chart that starts from a non-zero value.
#dataviz #map
Source: wybory.gov.pl/prezydent202...
#dataviz #map
Source: wybory.gov.pl/prezydent202...
May 19, 2025 at 10:46 AM
This is how you create a (white) hole in a map. I think it looks like a bar chart that starts from a non-zero value.
#dataviz #map
Source: wybory.gov.pl/prezydent202...
#dataviz #map
Source: wybory.gov.pl/prezydent202...
Multiple Stars in a Star Schema
www.powerofbi.org/2025/03/31/m...
Seeing an ideal “star schema” with only one fact table surrounded by multiple dimensions in almost every data modeling example doesn’t help those who are just starting to build their first data models...
www.powerofbi.org/2025/03/31/m...
Seeing an ideal “star schema” with only one fact table surrounded by multiple dimensions in almost every data modeling example doesn’t help those who are just starting to build their first data models...
Multiple Stars in a Star Schema - Power of Business Intelligence
Power BI developers learn that a star schema is the optimal data model design for usability and performance. However, seeing an ideal “star schema” with … Read More
www.powerofbi.org
March 31, 2025 at 9:12 PM
Multiple Stars in a Star Schema
www.powerofbi.org/2025/03/31/m...
Seeing an ideal “star schema” with only one fact table surrounded by multiple dimensions in almost every data modeling example doesn’t help those who are just starting to build their first data models...
www.powerofbi.org/2025/03/31/m...
Seeing an ideal “star schema” with only one fact table surrounded by multiple dimensions in almost every data modeling example doesn’t help those who are just starting to build their first data models...
I've deactivated my X account. I'll be here and on LinkedIn.
X is in Nazi hands.
Sadly, the US in Nazi hands as well... Dear US followers who do not support this madness, you don't have much (or any) time before the regime is strong enough to halt any opposition.
Take care!
X is in Nazi hands.
Sadly, the US in Nazi hands as well... Dear US followers who do not support this madness, you don't have much (or any) time before the regime is strong enough to halt any opposition.
Take care!
February 20, 2025 at 8:36 PM
I've deactivated my X account. I'll be here and on LinkedIn.
X is in Nazi hands.
Sadly, the US in Nazi hands as well... Dear US followers who do not support this madness, you don't have much (or any) time before the regime is strong enough to halt any opposition.
Take care!
X is in Nazi hands.
Sadly, the US in Nazi hands as well... Dear US followers who do not support this madness, you don't have much (or any) time before the regime is strong enough to halt any opposition.
Take care!
My favorite book review:
Amazon. Book "The Data Loom: Weaving Understanding by Thinking Critically and Scientifically with Data" by Stephen Few
Review: 1.0 out of 5 stars
THIS IS NOT A BOOK ON WEAVING TECHNIQUES. Was not paying attention, I guess. Very disappointed.
Amazon. Book "The Data Loom: Weaving Understanding by Thinking Critically and Scientifically with Data" by Stephen Few
Review: 1.0 out of 5 stars
THIS IS NOT A BOOK ON WEAVING TECHNIQUES. Was not paying attention, I guess. Very disappointed.
January 30, 2025 at 12:00 AM
My favorite book review:
Amazon. Book "The Data Loom: Weaving Understanding by Thinking Critically and Scientifically with Data" by Stephen Few
Review: 1.0 out of 5 stars
THIS IS NOT A BOOK ON WEAVING TECHNIQUES. Was not paying attention, I guess. Very disappointed.
Amazon. Book "The Data Loom: Weaving Understanding by Thinking Critically and Scientifically with Data" by Stephen Few
Review: 1.0 out of 5 stars
THIS IS NOT A BOOK ON WEAVING TECHNIQUES. Was not paying attention, I guess. Very disappointed.
#AI #OpenAI #ChatGPT Assistant for #TabularEditor
The assistant adds comments to the measures, and provides other forms of assistance, all while being aware of the entire data model.
The assistant adds comments to the measures, and provides other forms of assistance, all while being aware of the entire data model.
AI Assistant for Tabular Editor - Power of Business Intelligence
For now, this is just a quick proof of concept, but it works (at least it worked on my side). It consists of two C# … Read More
www.powerofbi.org
September 19, 2024 at 6:59 AM
#AI #OpenAI #ChatGPT Assistant for #TabularEditor
The assistant adds comments to the measures, and provides other forms of assistance, all while being aware of the entire data model.
The assistant adds comments to the measures, and provides other forms of assistance, all while being aware of the entire data model.
I finally posted a review. It's been a long time since I first read the book, however I still have it on my table as a guide for ongoing work.
A book about the future of data visualization in your organization.
#dataviz #ibcs 📊 #books
A book about the future of data visualization in your organization.
#dataviz #ibcs 📊 #books
Solid, outlined, hatched: How visual consistency helps better understand reports, presentations and dashboards - Power of Business Intelligence
Rolf Hichert and Jürgen Faisst’s Solid, Outlined, Hatched is an incredibly practical book about visual consistency that helps readers better understand reports, presentations and dashboards. … Read Mo...
www.powerofbi.org
September 3, 2024 at 4:35 PM
Something is happening at bsky!
I should start posting more regularly here.
I should start posting more regularly here.
September 3, 2024 at 4:33 PM
Something is happening at bsky!
I should start posting more regularly here.
I should start posting more regularly here.
If you have The Definitive Guide to DAX on your bookshelf, but not the Star Schema, then you’re trying to learn witchcraft in Hogwarts to cook a simple omelet for breakfast.
📖Star Schema The Complete Reference by Christopher Adamson
www.powerofbi.org/2024/08/23/s...
📖Star Schema The Complete Reference by Christopher Adamson
www.powerofbi.org/2024/08/23/s...
Star Schema The Complete Reference - Power of Business Intelligence
A data model is not a feature; it’s the core of a Power BI report. You can create a great report without using additional features … Read More
www.powerofbi.org
August 23, 2024 at 4:49 PM
If you have The Definitive Guide to DAX on your bookshelf, but not the Star Schema, then you’re trying to learn witchcraft in Hogwarts to cook a simple omelet for breakfast.
📖Star Schema The Complete Reference by Christopher Adamson
www.powerofbi.org/2024/08/23/s...
📖Star Schema The Complete Reference by Christopher Adamson
www.powerofbi.org/2024/08/23/s...
"Death by pie charts". Only in IMAX 3D. The World's Most Immersive Pie Chart Experience.
#PowerBI August 2024 Feature Summary powerbi.microsoft.com/en-us/blog/p...
#PowerBI August 2024 Feature Summary powerbi.microsoft.com/en-us/blog/p...
August 21, 2024 at 12:06 PM
"Death by pie charts". Only in IMAX 3D. The World's Most Immersive Pie Chart Experience.
#PowerBI August 2024 Feature Summary powerbi.microsoft.com/en-us/blog/p...
#PowerBI August 2024 Feature Summary powerbi.microsoft.com/en-us/blog/p...
May 21, 2024 at 9:53 AM
New version of my Pseudo Row Level Security (RLS) for Publish to Web Power BI Reports.
www.powerofbi.org/2024/05/20/p...
And I have a challenge for you. There is sales data for Liam Davis in the report. Can you “hack” the Publish to Web version and extract the data?
www.powerofbi.org/2024/05/20/p...
And I have a challenge for you. There is sales data for Liam Davis in the report. Can you “hack” the Publish to Web version and extract the data?
Pseudo Row Level Security (RLS) for Publish to Web Power BI Reports - Power of Business Intelligence
This post is an update for A Critical Issue Has Been Fixed One of the users has found a critical issue: the Text Filter visual … Read More
www.powerofbi.org
May 20, 2024 at 1:17 PM
New version of my Pseudo Row Level Security (RLS) for Publish to Web Power BI Reports.
www.powerofbi.org/2024/05/20/p...
And I have a challenge for you. There is sales data for Liam Davis in the report. Can you “hack” the Publish to Web version and extract the data?
www.powerofbi.org/2024/05/20/p...
And I have a challenge for you. There is sales data for Liam Davis in the report. Can you “hack” the Publish to Web version and extract the data?
How to Make “Cool” and “Fancy” BI Report
How to Make "Cool" and "Fancy" BI Report - Power of Business Intelligence
Your BI report isn’t “cool”? It lacks “cool” backgrounds, effects (3D, shades, gradients), and “cool” images and icons, etc.? Do you want to make your … Read More
www.powerofbi.org
May 16, 2024 at 10:32 PM
How to Make “Cool” and “Fancy” BI Report