A recent post on the Power BI community website asked if it was possible to compress a group of numbers into text that described the sequential ranges contained within the numbers. This might be a group of values such as 1, 2, 3, 4, 7, 8, 9, 12, 13: (note there are gaps) with the Read more about Fun with DAX – Compressing Numeric Sequences to Text[…]
In this post, I am going to show you how we can create most comprehensive Custom visual. In the last two posts published in July 2017 (post1 and Post 2). Some notes before I am going to complete the last two posts. 1- We able to declare some custom input like X, Y, Legen and Read more about Create Custom Visual with R and JSON- Part3[…]
Using bookmarks for clearing all slicers in Power BI is not a a new function, I have been using it for many months, and advising many people to do it that way. However, I still get a lot of questions in my presentations about how to do that. That is why I ended up writing Read more about Clear All Slicers in Power BI; A Bookmark Story[…]
I normally work with most of the Microsoft tools for the aim of doing machine learning. I came up with a roadmap that shows what option for machine learning we have with Microsoft tools in Data Platform. this roadmap is not completed yet, I need to update it one later with some tools such azure Read more about Road Map to use Microsoft ML tools[…]
Implementing a Power BI solution is not just about developing reports, creating a data model, or using visuals. Power BI, like any other technologies, can be used in a correct, or incorrect way. Any technology can be used more effective if it harnesses the right architecture. A right architecture can be achieved after a requirement Read more about Power BI Architecture Guidelines[…]
Power BI Report Server can host Power BI reports on-premises, and you’ve learned about it in the previous post. There is another integration between SQL Server Reporting Services and Power BI service; this integration brings tiles from SSRS reports pinned to a Power BI dashboard with scheduled updates from SQL Server agent. The integration of Read more about SQL Server Reporting Services Integration with Power BI[…]
If you work for an organisation that stores thumbnail images of staff inside Active Directory, you can probably access these and incorporate the images in your Power BI Reports. This is a great way of making an internal staff report look fantastic – and it’s easy! Step 1. Click Get Data from the Home tab Read more about Add Photos to Power BI from Active Directory[…]
I am seating in the front row of keynote for Data and BI Summit 2018 in Dublin ran by Dynamic Communities. There will be some great announcements today about upcoming Power BI features. Here in this blog post I will list these features. Incremental Refresh The most wanted feature of Power BI for refreshing data Read more about Power BI Announcements in Data&BI Summit 2018 Dublin Keynote[…]
Part 1 of 3 Using RANKX in calculated measures Part 2 of 3 Using RANKX in calculated columns This article concludes my epic series detailing how to use the RANKX function in DAX. In this episode, Frodo finally reaches Mt. Doom and successfully uses RANKX to find the best path into the mountain and complete Read more about How to use RANKX in DAX (Part 3 of 3 – The Finale)[…]
RevoScaleR Package RevoScaleR is packages created by Revolution Analytics (own by Microsoft) with the aim of importing, transforming, and analyzing data at scale. There are different categories of functions for the data store, imports and save as, data transformation, draw some charts such as histogram, line and so forth, descriptive analysis, predictive analysis, package Read more about Microsoft SQl Server ML Services: RevoScaleR Package[…]