Tag: Power BI

Single-letter day and month names in Power BI
Single-letter day and month names in Power BI
Blog Posts

Occasionally in Power BI, you may want to display day or month names as single letters to save space. This may result in duplicates because neither day nor month names are unique when you shorten them to one letter. In this blog post, I’m showing two solutions to the problem: one in DAX and one… READ MORE

Exploring Power BI In Microsoft Teams
Exploring Power BI In Microsoft Teams
Blog Posts

In this article, we will be talking about the new Power BI experience in Microsoft Teams. During Ignite 2020, Microsoft announced that users can now use Power BI Service from teams without leaving the context of Teams. This feature is very useful for modern workspace users where we can use Microsoft Team as a centralized… READ MORE

Slicer Pain Relief in Power BI!
Slicer Pain Relief in Power BI!
Blog Posts

Hidden gems! Slicer Pain Relief in Power BI! Power BI is full of them…Sometimes, you find them after thorough research, and sometimes they just appear out of nowhere. This post won’t be long – it’s just an homage to Power BI and one of its handy features that will make your life easier in specific… READ MORE

Automate your Power BI Reports Deployment using Azure DevOps
Automate your Power BI Reports Deployment using Azure DevOps
Blog Posts

This article will guide you through the implementation of CI/CD pipelines using Azure DevOps. This will enable you to deploy your local report to your Power BI service automatically. To show you how it works, I will use an extension called Power BI Actions, available for free on the Visual Studio marketplace. Azure Portal Create a… READ MORE

Power Pivot and Power BI
Power Pivot and Power BI
Ebooks

Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Download 2 Chapters: 8 – CALCULATE() –… READ MORE

Currency Conversion in Power BI Reports
Currency Conversion in Power BI Reports
Blog Posts

Currency conversion applied to BI reports can include many different scenarios. Data in multiple currencies, report with a single currency Data in multiple currencies, report with multiple currencies Data in a single currency, report with multiple currencies The rule of thumb is to apply the currency exchange conversion upfront. Therefore, it is a good idea… READ MORE

Power BI Security
Power BI Security
Blog Posts

A common topic I have been discussing recently with customers is the security around Power BI. Basically, how to prevent users seeing data they shouldn’t. So I’ll discuss the various “layers” of security. The Power BI service architecture is based on two clusters – the Web Front End (WFE) cluster and the Back-End cluster. The WFE cluster… READ MORE