What is Azure Map in Power BI: Part One

Reza rad already wrote some articles about Map visuals in Power BI such as ArcGIS, Shape Map, and Filled Map. In this blog post, I am going to talk about Azure Map Visual in Power BI. a definition from Microsoft website: “The Azure Maps visual for Power BI provides a rich set of data visualizations Read more about What is Azure Map in Power BI: Part One[…]

Page-Level Security workaround in Power BI

If you want to control the access to the Power BI report pages (or tabs) in a way that some users see some pages, and some others see other pages, we need something called page-level security. However, Power BI, as of today, doesn’t support visual-level or page-level security. There is a workaround to do it. Read more about Page-Level Security workaround in Power BI[…]

Sync Slicers in Power BI

In some of the reports with many pages, some of the slicers are common, and all pages need to have them. Moreover, in some data analysis approach, we may want to apply one slicer, not on-page, but in all other pages in our reports. In this scenario, we need to use the sync slicers option Read more about Sync Slicers in Power BI[…]

Power BI Bookmarks: Grouping

Bookmarks are a way of storytelling, There are many examples of using Bookmark to show narrative storytelling check Reza Rad blog post on “Bookmarks and Buttons“. Imagine you created several bookmarks from different pages you have in the Power BI file. however, not all bookmarks are related to the same story. One related for example Read more about Power BI Bookmarks: Grouping[…]

Why data preparation and transformation? Why Power Query?

Does Power Query requires training or reading a book, or even reading an article? I get this question a lot from those who started Power BI not long ago. Many users think that Power Query is just the get data from the source, and that’s it. Considering the many data source connectors in the Power Read more about Why data preparation and transformation? Why Power Query?[…]

Book Overview: Power BI DAX Simplified

A few weeks ago, my new book was published and is now available. As the Amazon web page for the book won’t allow me to put some more details about what it is, I thought it better to share some more information about it here. This book is available in all possible Amazon markets as Read more about Book Overview: Power BI DAX Simplified[…]

Take Your Power BI Visualization to the Next Level using Small Multiples

Small multiple is a relatively recent feature on some of the Power BI visuals. This feature enables you to have a much better visualization instead of trying to fit everything in one visual (over-complicate it) or create copies of the same visual (maintenance issue in the future). This is a simple feature to use, which Read more about Take Your Power BI Visualization to the Next Level using Small Multiples[…]

Explicit Vs Implicit DAX Measures in Power BI

Have you ever tried to connect to a Power BI dataset from Excel using Analyze in Excel? if yes, you might have had this experience that your values don’t show in Excel’s Pivot table as values. This is because those values are not explicit measures, they are implicit measures in Power BI. In this article Read more about Explicit Vs Implicit DAX Measures in Power BI[…]

Power BI Bookmark: With or Without Data

Bookmark is a helpful feature in Power BI. It enables you to have a good story to tell and also have a dynamic visualization. I have explained how bookmarks work in Power BI and how to use them with buttons to have a next-level visualization. An important attribute of the bookmark is the Data. You Read more about Power BI Bookmark: With or Without Data[…]

Fuzzy Clustering in Power BI using Power Query: Finding similar values

I have written two articles about fuzzy operations in Power BI and Power Query so far;  fuzzy matching in Power BI, and fuzzy grouping. the methods above involve transforming the data with a fuzzy operation. However, sometimes you just want to know the similarity of values, or let’s say in other words; find the clusters. Read more about Fuzzy Clustering in Power BI using Power Query: Finding similar values[…]