Dashboards that Interact on Cell Clicks
Today I was viewing one of the earliest Dashboards I created. This is one of the favorites of my colleagues.[…]
Read moreAuthor: Abu Hasan
EARLIER in DAX
EARLIER function is hard to understand in first go but it is even harder to explain. “EARLIER” is needed when[…]
Read moreARRAY FORMULAS
Array formulas are powerful formulas in Excel that perform calculations using multiple ranges of cells. They are also known as[…]
Read moreCustomized Sorting and it Limitations
Quite often we need Customized Sorting for our lists, pivot tables and slicers. Being an accountant and working with Financial[…]
Read moreCONTEXT TRANSITION using CALCULATE
A fundamental difference between the two contexts in DAX is that a row context does not propagate through or follow[…]
Read moreDynamic Named Range
Dynamic Named Ranges can be very useful in creating Interactive Dashboards and Charts. I created the Interactive Chart below using[…]
Read moreScroll Bar (Form Control)
Scroll Bars in Excel Dashboards In this post I am going to show you how to use Scroll Bars to[…]
Read moreVALUES FUNCTION AND PARAMETER TABLES
VALUES FUNCTION and PARAMETER(UNRELATED) TABLES One of the beauties of DAX is that a data modeler can set up her[…]
Read morePower BI Charts’ Interactions
By default, Power BI data charts interact each other in the following manner. i.e. An item selection in a chart[…]
Read moreWhat it Takes to Master Excel
MASTERING EXCEL WHAT TO MASTER To become awesome in Excel, you need to master key areas/topics in Excel. For me,[…]
Read more