Power BI

Data Profiling, in other words identifying the sources and checking the quality of the data is a part of a BI project. But how important it is and how much it effect to the success of a BI project? Th…

This post explains how to use Power BI DAX measures in an efficient way, when there are multiple disconnected slicers that you want to use.

We were recently building a data model with on-prem Dynamics data mostly using the OData feed (v8.2). This article only scratches the surface of what is possible with OData (including update/write functions and much more complex queries than those shown here), but we did pick up a few tricks that were worth

I have given many presentations and talks about Data Visualization, and still, I am amazed by how many visualizations I see which is not following the basic rules. In this article, I want to focus on …

How to hide and show bookmarks based on values in your data

Reading Time: 3 minutes One of the new features that Microsoft announced in February’s Power BI Desktop update is the Improved Python & R Script Editor. The script editor now contains the same features as the DAX editor, including IntelliSense for code completion. After spending some time with the new editor though, I made a discovery about the code completion.…

This blog post details how to refresh one table in a Power BI Data Model. Allowing a user to quickly refresh their required data.

Patrick walks you through how to use a Power BI quick measure and then easily modify it. In this example, he uses the concatenated list of values quick measure in Power BI Desktop.

This article discusses a few little-known facts about the Sort by Column feature of Power BI.

Patrick looks at a customer scenario where he found Power BI tooltips causing report performance issues. He shows how to identify and then a possible solution.

In this blog post FourMoo details how to use the new Power BI Rounded Borders feature to make stunning charts, which will enable better visualisation.

The February 2019 release of Power BI Desktop unveiled a new, out-of-the-box visual to Power BI called Key Influencers. Key Influencers is Power BI’s first AI powered visualization. Microsoft has long incorporated AI capabilities in Power BI through features such as Q&A and Quick Insights.

The newest version of the Power BI Desktop and Power Query for Excel, you can combine multiple data from Excel files into one big tall table.

The month of February 2019 witnessed the release of Power BI Desktop unveiled a new, out-of-the-box visual to Power BI called Key Influencers.

Register for this webinar to learn how Microsoft Power BI helps you manage financial planning and analysis more easily and effectively.

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup129 2 Minute Tuesday: https://guyinacu.be/geekshirts Patrick’s tech video: https://guyinacu.be/webfromexample Adam’s tech video: https://guyinacu.be/adminportal Sources Calculation Groups in DAX – first impressions (@marcorus) EXPLORING POWER BI’S KEY INFLUENCERS (@Jcrit44) Power BI Premium Deployment and Management Whitepaper added! Tailoring help and support for Power BI […]

This month we have a lot of exciting announcements. Two of our most requested features on UserVoice are releasing this month, heat maps and single select slicers. Additionally, we are making our complete facelift of the modeling view generally available. New DAX functions and improvements to existing features, such as buttons and the selection pane, round out this update.

What is Multivariate Reporting and when is it helpful? Multivariate Reporting (also known as Small Multiples) uses a series of visuals with the same measure and same scales but showcases various partitions of the data. The benefit is that you can allow your report consumers to easily compare the same measure across dimensions and all … Continue reading “How to do multivariate reporting with Power BI”

We’re looking for business professionals who use Microsoft Power BI and/or manage Power BI accounts to join our research panel.

Today we presented at the 5th annual Gartner BI Bake Off session at the Gartner Data and Analytics Summit in Orlando, Florida and we are very excited to share the report with everyone. The topic this year is loneliness data from the Kaiser Family Foundation and The Economist Same as last year, a little bit of background: … Continue reading “BI Bake-Off at Gartner Data and Analytics Summit 2019”

I have written about Date Dimension in Power BI in many posts, and it makes sense now to explain one of the most common performance challenges that I see in some of the models. Sometimes, your model size grows significantly big, and you have no idea why!? In this article, I will show you one…

This is the weekly Power BI RoundUp, where there are updates to Power BI Desktop, Power BI Service, Azure Business to Business & Webinar

The article that I wrote earlier this week about the shared dimension had a lot of interest, and I'm glad it helped many of you. So I thought better to write about the basics of modeling even more. In this article, I will be focusing on a scenario that you have all faced, however, took…

Sometimes a requirement in a project is to have visual that represents a trend over time. Easy. Value, on the axis some time dimension values and voila! Easy as pie. Well, however, then there’…

Some time ago a customer of mine (thank you, Robert Lochner) showed me a very interesting scenario where a set of Power Query queries in Power BI Desktop refreshed a lot faster with the “Enable Par…

PowerBI Data Comparison Tool Here is a PowerBI Document designed to show differences in data from two similar data sets Its a common, but difficult requirement to check data sets against each other. T…

Mark V SQL - Mark Vaillancourt: Data Nerd