RADACAD Blog

Latest Power BI and AI articles from RADACAD team

Removing Blanks from Organizational Ragged Hierarchy in Power BI Matrix Visual

Posted on by Reza Rad

I have previously written how to create a ragged hierarchy, which can be used for organization hierarchy or chart of accounts or similar scenarios. A ragged hierarchy is a hierarchy with un-even number of levels. In a parent-child scenario of organization hierarchy, for example, the CEO is the highest level of the organization, so won’t Read more about Removing Blanks from Organizational Ragged Hierarchy in Power BI Matrix Visual[…]

New component of Azure ML Service – Visual Interface

Posted on by Leila Etaati

Azure ML services has been introduced for a while, however in the last Microsoft Build, the visual interface of azure ml service has been introduce that has so much similarity to Azure ML Studio. however there are some difference between them as the created experiment in visual interface be shown in the Assets section as Read more about New component of Azure ML Service – Visual Interface[…]

Only Get the Last Few Periods of Data into Power BI using Power Query Filtering

Posted on by Reza Rad

Power BI reports can get slow if you have huge amount of data. One of the ways to speed up the performance is to get the smaller part of the data, only the part that is needed for analysis. Most of the times, a date condition is a good filter for that. You might only Read more about Only Get the Last Few Periods of Data into Power BI using Power Query Filtering[…]

Power BI Training Self Assessment: What Training Path Should I Take?

Posted on by Reza Rad

You want to see which Power BI training option is good for you. You want to see should you start from the beginning or focus on a specific component of Power BI? This is the question that I often get asked when people come to me and asking about bespoke training for their teams. Here Read more about Power BI Training Self Assessment: What Training Path Should I Take?[…]

Some Methods for Calculating Quarter in DAX for Power BI

Posted on by Reza Rad

You might have wondered that there is no DAX Quarter function in Power BI. Here in this short blog post, I explain some easy methods for calculating quarter. If you like to learn more about Power BI, read Power BI book from Rookie to Rock Star. Sample Data To start this example, you can open Read more about Some Methods for Calculating Quarter in DAX for Power BI[…]

Custom Format Fields and Measures in Power BI

Posted on by Reza Rad

If you have been watching Power BI news recently, you know that Power BI fields now support custom formatting. In this short blog article, I am going to explain how to use this feature to achieve your custom formatting. You can do things like showing () for negative values, showing custom date/time formats, and etc. Read more about Custom Format Fields and Measures in Power BI[…]

Some of Key Influencers Visual Features

Posted on by Leila Etaati

Key Influencers visual is now generally available ( no preview ), so having updated version of the  Power BI desktop, it is no more a preview feature. This visual is a good one for analysing the data. as I have explained in the post about it ( see here). Now let see some other features Read more about Some of Key Influencers Visual Features[…]

From and To Date Slicers in Power BI: Filtering Based on Two Fields

Posted on by Reza Rad

Power BI date slicers can be used to filter based on one field. However, what if in your dataset, you have a FROM and TO (or Start and End) Date? In that case, you’d most probably want to use the slicer to filter the report in such a way that it shows all data in Read more about From and To Date Slicers in Power BI: Filtering Based on Two Fields[…]

Scheduled Snapshot of the Power BI Data and Report

Posted on by Reza Rad

How many times you have been thinking to see is this possible to store the data of the Power BI report every day, every week or month. How many times, you thought of how to take a snapshot of the data in the Power BI dataset or report at a specific point of times? Well, Read more about Scheduled Snapshot of the Power BI Data and Report[…]

Using Data Category to Have a Better Visualization in Power BI

Posted on by Reza Rad

There are some field properties in Power BI such as formatting, which is obvious to use. However, some configurations on the field level, such as Data Category, is not very well known. Data Category is a configuration that can be helpful in multiple visualizations, In this short article, I’m explaining how to use this option Read more about Using Data Category to Have a Better Visualization in Power BI[…]