In the first two parts (part 1 and part 2) of the blog we explored the Show details functionality of a Pivot table in Excel. Now we look at another hidden feature that will help you limit distractions. Whenever you connect to...
Category - Analytics Edge
This blog series is about the hidden features in Analyze in Excel. There are lot of tiny details which can help the adoption of Power BI for Excel users. In this blog we are going to talk about increasing the records retrieved by...
This blog series is about the hidden features in Analyze in Excel. There are lot of tiny details which can help the adoption of Power BI for Excel users. In this blog we are going to talk about Detail Rows Expressions.
I have been reading a lot of good feedback of the Power BI May 2022 update especially and the introduction of field parameters. Do not want to go into details what it is, because the official blog post and video gives a good...
Slicer and filter were around in Power BI for a long time now, and plenty of blog posts were created comparing them to each other. Because these features constantly get updated and there are considerations outside of just a...
Turn Best Practice Analyzer recommendations into Custom Actions in Tabular Editor. Improve your data models with a few clicks.
This blog post want to help how to understand the reasons and give you a starting point for improvements in Power BI report performance. Won’t cover all the options in-depth instead will point you to a useful youtube video...
I started collecting the different built-in analytics capabilities of Power BI. (You can find Part 1 and Part 2 here.) As I went through all the possibilities I found that I really miss the ability to define the 2 months I would...
In this part of the series we will look into the different Analyze options of Power BI. Previous part of this series can be found here. Explain the Increase/Decrease This is the first type of the Analyze features. If...
As I work with Power BI sometimes I encounter strange behaviours that I not heard before, and sometimes feel unintentional by the developers. I have to be honest I am not sure it is not documented, I just did not found it. The...