New Card Visual: Add Images to the Card Visual

One of the interesting features of the New Card visual is the capability to add images to the Card visual.It added more context to the car visual. In this blog post, I will show some data related to cancer in New Zealand based on gender and cancer type. Now I made two changes first if Read more about New Card Visual: Add Images to the Card Visual[…]

Microsoft Fabric Notebook: What and Why?

One of the objects in the Microsoft Fabric is the Notebook. If you haven’t worked with Azure Notebooks before, you might ask yourself; what is Notebook? Why should I use it? These are questions that we will answer in this article. Video What is Microsoft Fabric Microsoft Fabric is an end-to-end Data Analytics platform software-as-a-service Read more about Microsoft Fabric Notebook: What and Why?[…]

Convert Matrix data in Excel to Tabular Data in Power BI.

There is a common way of seeing data in Excel as a Matrix format; many data entries look like a matrix in many contexts, from accounting to health data. However, to better analyze data and add more calculations and charts and, in general, get more insight from data, we need to change the matrix data Read more about Convert Matrix data in Excel to Tabular Data in Power BI.[…]

Calculating the trend of a Chart using DAX ( Smoothing Moving Average)

Calculating the trend of a line chart can be possible using the Analytics tab under the format section of the chart. What if we need to store this calculation and reuse it or show it as a separate chart? Actual Chart as below The trend of the chart The first question is about calculating the Read more about Calculating the trend of a Chart using DAX ( Smoothing Moving Average)[…]

Using Cognitive service for Translation in Power BI

There is a possibility to call cognitive service for translation inside Power Query. I will use this to translate 3000 rows of data about people arrested in Iran for protesting; This information contains city Name, Fullname and Other statements. In this article, I will show how to call cognitive services for translation, create a proper Read more about Using Cognitive service for Translation in Power BI[…]

Azure Machine Learning Call API from Power Query

This was my longtime aim to create this post, and finally, I will write about it here on how to call Azure ML Rest API inside Powe Query even if you don’t have Power BI Premium.Of course, some limitations on the number of API calls need to consider while using your Rest API.Thanks to Chris Read more about Azure Machine Learning Call API from Power Query[…]

Template Power BI File for Sessionize.com

Organizing events always start with session selection and finally creates a schedule on it. As I was busy always with community activities, I am using sessionize website a lot, this website is free of charge for free and nonprofit conferences, but for the paid conference, you need to pay as you using it ( fair Read more about Template Power BI File for Sessionize.com[…]

Sort Column Name in Power Query via M Code

Sometimes people ask questions about how to order columns in Power query, mostly for Queries with Lots of Columns. We can reorder column Name with Drag and Drop or use Move in GUI to change the column’s order, but it is also possible to reorder via code. In this post, I will show how to Read more about Sort Column Name in Power Query via M Code[…]

How to set Workspace inside Azure ML SDK

Working With Azure ML workspace can be more flexible with Azure ML SDK. In this section, we are going to see how to set a workspace via AzureML SDK inside Notebook. in summary how to access the config file for the Azure ML workspace will be shown, and how to set a new workspace with Read more about How to set Workspace inside Azure ML SDK[…]

Market Basket Analysis in R Part 3

About a couple of years ago, I wrote two articles about what is association rules and how we can have them in Power BI.In this post, I am going to put some more enhancements and show you how with data that is not cleaned how you can create Market Basket Analysis. these enhancements are about Read more about Market Basket Analysis in R Part 3[…]