Power BI

Power BI

7501 bookmarks
Custom sorting
Hierarchies with dynamic levels in Matrix by Field Parameters
Hierarchies with dynamic levels in Matrix by Field Parameters
In a previous article about Field parameters, I spoke about using them in cooperation with Calculation groups (LINK). I used them to get specific measures for selected dimensions from the dimensions field.
·linkedin.com·
Hierarchies with dynamic levels in Matrix by Field Parameters
Introduce the DAX EvaluateAndLog Function
Introduce the DAX EvaluateAndLog Function
There is a hidden gem in the August 2022 release of Power BI Desktop: a secret new DAX function EvaluateAndLog that is not listed in the feature summary of the official blogpost. Yet this function …
·pbidax.wordpress.com·
Introduce the DAX EvaluateAndLog Function
Should you hide the filter pane in Power BI?
Should you hide the filter pane in Power BI?
My opinion on hiding the filter pane, what my personal preference is as well as the reasons why.
·greyskullanalytics.com·
Should you hide the filter pane in Power BI?
A Power BI Gateway Monitoring & Troubleshooting Solution
A Power BI Gateway Monitoring & Troubleshooting Solution
One of the main challenges I see #powerbi admins of large enterprises is monitoring & troubleshoot all their on-prem Gateway Clusters. Each cluster has multiple gateway servers that are responsible to connect the Power BI service in the cloud to customer data sources, sometimes there are errors in t
·linkedin.com·
A Power BI Gateway Monitoring & Troubleshooting Solution
Clarity and Aesthetics in Data Visualization: Guidelines
Clarity and Aesthetics in Data Visualization: Guidelines
Last week I introduced mini-projects as one pillar of my graduate visualization course. A interesting outgrow of that activity is a set if data visualization clarity and aesthetics guidelines we developed over time while reviewing the solutions our students submitted for these exercises.
·filwd.substack.com·
Clarity and Aesthetics in Data Visualization: Guidelines
What Matters, Really, is Effective Data Thinking
What Matters, Really, is Effective Data Thinking
Reflections on my frustration teaching data visualization without focusing on effective data-driven thinking
The project requires students to formulate a data analysis and presentation goal and to generate (1) a series of “data questions”; (2) corresponding data transformations and models; and (3) a set of initial sketches of the associated visual representations.
mottos in the course is that data visualization is not only about visual representation, but also about asking good questions and generating appropriate information from the data
I do not have a definite answer to these questions, but I can’t help but notice that we, as a community, may be at fault here. With our obsession with whether a pie chart is “better“ than a bar chart, is it possible that we have lost sight of what actually really matters? Let me be blunt: it does not really matter how pretty a visualization is and whether it uses the latest technology or the fanciest graph. These are nice things to have, for sure. But at the end of the day, what really matters is thinking. Appropriate and effective thinking.
·filwd.substack.com·
What Matters, Really, is Effective Data Thinking
Power BI Viz Tricks - Line chart target areas
Power BI Viz Tricks - Line chart target areas
A few months ago, I was asked to build a line chart with target areas, something like the chart below (which by the way will be our final solution!): At the time I could not really find an easy way to achieve this... Until error bars came out! Don't be fooled though, it's still a bit tricky to build a line chart like this, however I found it way easier now than before. So, you must be thinking now "how did you do that?". Well, let's find out! 1) I started out with my base chart, which is just sh
·datapears.com·
Power BI Viz Tricks - Line chart target areas
Power BI Ideas site improvement updates
Power BI Ideas site improvement updates
Our Ideas site has been the main place for you to leave suggestions. the past year we have made improvements to the ideas site to keep the site secure, spam free and allow users to submit ideas through the Ideas portal. Many of you have since shared feedback and suggestions on how we can further improve the ideas site. Today we would like to share the upcoming roadmap and improvements we have planned for the Ideas site to address the feedback that has been raised.
·powerbi.microsoft.com·
Power BI Ideas site improvement updates
What Makes a Data Visualization Confusing?
What Makes a Data Visualization Confusing?
Why are some visualizations so easy to understand at first sight while others seem to be some sort of graphical puzzle? Why do some visualizations need to be relearned every time you see them again, whereas others need only one simple initial exposure?
I believe there are two distinct phenomena in this space that often get conflated: novelty and something I’ll tentatively call cognitive incongruence.
While, for sure many representations are confusing only at first sight and have a learning curve, it is also clear to me that some representations are confusing no matter how many times you use them
If we set aside the clear case of visual representations that are confusing only at first because they are novel, it would be interesting to understand better what makes some graphs confusing even after multiple exposures. It seems to me there could be interesting insights to gain from such an exploration.
An example of the second case is the burning embers I mentioned above. To me, they look a lot like bar charts, so when I see them, I try to read them as bar charts, which is the wrong mental model for them. A similar problem exists with connected scatter plots. I want to read them as line charts, but this is the wrong way to read them, so I get confused.
One hypothesis I have is that they evoke the wrong analogies, either because there is a mismatch between the visual representation and the information they represent or because there is a clash with mental models of similar representations we have acquired in the past.
different in different cultures
·filwd.substack.com·
What Makes a Data Visualization Confusing?
What are Power BI Dataflows and their Use Cases?
What are Power BI Dataflows and their Use Cases?
Dataflows are an important component in the Power BI architecture. Using them can enhance the development and maintenance of your Power BI solution significantly. However, there are many Power BI …
·flip.it·
What are Power BI Dataflows and their Use Cases?
Training Power BI End-Users with reporTee — DATA GOBLINS
Training Power BI End-Users with reporTee — DATA GOBLINS
Training users is important in every Power BI project. It’s particularly important when implementing Power BI, or if users are not familiar with Power BI reports. However, creating good training material is time-consuming, and difficult. In this article, I introduce reporTee, a licensed, out-of-the
·data-goblins.com·
Training Power BI End-Users with reporTee — DATA GOBLINS
Introduction to datamarts - Power BI
Introduction to datamarts - Power BI
Introduction to datamarts5 minutes to read3 contributorsBusiness users rely heavily on centrally governed data sources built by information technology teams (IT), but it can take months for an IT …
·flip.it·
Introduction to datamarts - Power BI
Power BI: Data Quality Checks Using Python & SQL
Power BI: Data Quality Checks Using Python & SQL
Picture this, you have a report in Power BI that someone passes off to you for data quality checks. There are a few ways to make sure your measures match what is in the source data system, but for …
·dataonwheels.wordpress.com·
Power BI: Data Quality Checks Using Python & SQL
Building an arbitrary YOY% Chart with Zoom-out Tooltips
Building an arbitrary YOY% Chart with Zoom-out Tooltips
An arbitrary YOY% Chart with Zoom-out Tooltips is good to compare growth at different levels of aggregation. This article explains how to do it in PowerBI
·esbrina-ba.com·
Building an arbitrary YOY% Chart with Zoom-out Tooltips
Chris Webb's BI Blog: Yet Another Power BI (And Synapse) Book Roundup
Chris Webb's BI Blog: Yet Another Power BI (And Synapse) Book Roundup
I like free stuff and I like books, so of course I like free books – and it seems that the more I provide free publicity for relevant books here the more free books I get sent. I’ve now…
·blog.crossjoin.co.uk·
Chris Webb's BI Blog: Yet Another Power BI (And Synapse) Book Roundup