Power BI

Hello everyone! I am trying to compute SUM of TOP N values in a table in a time period specified via slicers using following measures: 1. VolumeSum = CALCULATE(SUM(Volumes[Volume]); Volumes[Dimension]="mln l") 2. VolumeRanks2 = RANKX(ALL(Producers[Producer Eng]); CALCULATE(SUM(Volumes[Volume]); ...

You can now use natural language queries in Power BI Desktop, using Q&A

Register for exam 70-778, and view official preparation materials to get hands-on experience with analyzing and visualizing data with Microsoft Power BI.

The MCSE: Data Management and Analytics certification demonstrates your broad skill sets in SQL Server administration and leveraging business intelligence.

Earn your Microsoft Certification. Discover how our certification program can help you earn college credit, expand your skills and advance your career.

Learn the skills you need to help land the career you want!

SlopChartRViz SlopChartViz is a custom visual for showing the trend between two times. There is a possibility to zoom in an zoom out in this chart. This custom visual needs: 1- First Variable: a group…

TblChartRViz TblChartRViz is a custom visual for showing five variables in one chart. There is a possibility to zoom in and zoom out on this chart. This custom visual needs: 1- X-axis as the first var…

ScatterRViz ScatterRViz is a custom visual for showing three variables in one chart. There is a possibility to zoom in and zoom out on the chart. This custom visual needs 1- X-axis as the first variab…

Even though it is almost the holiday season, the wonderful people from the Power BI team have given myself (and hopefully you also) some early birthday presents. So please find all the updates belo…

Mark V SQL - Mark Vaillancourt: Data Nerd

I’ve seen a few scenarios where Office 365 modern groups were depended on for security access, but when trying to use them within Power BI you will find they are not available. Power BI really…

While on a recent project I needed to build a variation of the DAX date table. In my previous post, found here Creating DAX Date Tables I was built a date table for every day of the month for mult…

Better late than never. Prior to 2017 Power BI Data Insights Summit, Microsoft published here three challenges, including a complex data preparation. So, I had to try it. At the time, I was too busy to submit my solution, but I planned to share it at DataChant. You can also learn how the challenge was solve …

Mark V SQL - Mark Vaillancourt: Data Nerd

My colleague and friend Meagan Longoria has been giving me a few “gentle nudges” to update an old post about this topic: This post is a checklist of suggested items to be completed in your Power BI data model, within Power BI Desktop, before you consider it “done done.” This is not a how-to pos

Report powered by Power BI

Report powered by Power BI

Dynamic attributes and how to implement them in Power BI Desktop or Power Pivot using “Harvester” measures and disconnected slicers.

In the mathematical field of numerical analysis, interpolation is a method of constructing new data points within the range of a discrete set of known data points. Anyone that has done mechanical engineering knows all about interpolation. I swear my Thermo and Fluids professor, Dr. Jed Marquart was ...

Font selection is one important but often overlooked aspect of creating content in Power BI. With the June 2017 Power BI Desktop update, the ability to change between font families expanded substantia…

Hi readers, Happy New Year! It’s been a while since I blogged and a lot of changes have happened in the last one year, including me moving to Microsoft as a BI Technology Solution Professional in t…

Hi , Please try below measures: Count transaction = COUNT('User-transaction'[TransactionID]) Rank value = RANKX(ALLSELECTED('User-transaction'[User]),[Count transaction],,DESC,Dense) Best regards, Yuliana Gu

Every month Power BI gets an update that adds a nice handful of new features. Let's read about this month’s awesome feature…Bookmarks.

Now that we’ve solidly gotten through the basics in terms of what connection types are in the opening blog, found here, and detailed out what is included in the default connection type of Import fo…