How to Create a Pareto Chart in Power BI Desktop
In this tip we look at how to create a Pareto Chart which applies the Pareto principle aka the 80/20 rule using Power BI Desktop.
2019-10-01
In this tip we look at how to create a Pareto Chart which applies the Pareto principle aka the 80/20 rule using Power BI Desktop.
2019-10-01
In this tip we look various map visualizations like Bubble, Shape and Filled Map visualizations you can use with Power BI.
2019-08-09
Steve has a few issues with the design of the Power BI Service and their format for storing reports.
2019-06-22
464 reads
Ginger Grant shares a few tricks to make it easier to upgrade from Power BI Data Model to Tabular.
2019-05-31
Power BI is an excellent tool for departments or small organisations getting started with their BI solution. Unless some time is spent organising the solution, however, it can become...
2019-05-17
Patrick looks at how you can get relative dates, in Power BI Desktop, without using the relative date slicer or relative date filters. You just need to sprinkle a...
2019-05-15
Fact tables are the core of analysis in a data model. In the previous article, I explained what a dimension table is, and why we cannot have everything in...
2019-05-14
2019-05-13
How can you find the cause of slow performance issues in Power BI? This post demonstrates some of the advanced tools you can you to test slowing performing queries...
2019-05-11
This article describes how to correctly use column references when manipulating tables assigned to DAX variables, avoiding syntax errors and making the code easier to read and maintain. Using...
2019-05-11
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Comments posted to this topic are about the item The Hidden Security Risks of...
Comments posted to this topic are about the item The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers