One beauty of Power BI is the capability of being dynamic. With Power BI Desktop, there are many functionalities that can enable the dynamic report
Month: December 2022
In this article, let’s look at a powerful technique – calculation group. It’s powerful, but surprisingly simple. It just needs two things, an external tool
Requirements: In some situation, business user particularly like a card to display a number of KPI, such as Total Sales, Average Sales per Product, etc.
As an effective person, one of my “secrete” is to understand my strengths and behaviors, and then develop strategies to meet and exceed the demands
Ranking is a common but tricky function in Power BI, especially when it comes to “dynamic ranking”. Requirement: Rank resellers in a table based on
Data governance is “a system of decision rights and accountabilities for information-related processes, executed according to agreed-upon models which describe who can take what actions,
Create a dynamic time range for forecasting Acquisition count in a certain mount of days, based on users’ selection. Solution: 1.Calculate the number of days
Do you still remember the excitement when you first wrote a DAX function that produce the correct calculation? Do you also remember the frustration when
My professional life is mostly related to business analysis, reporting, operation, and people management, which is not design again. Lucky enough, when working with GreenTown