Value or X-Axis of charts should not be truncated for Column/Bar and similar charts
Microsoft Excel automatically truncates the VALUE Axis or X-Axis of charts when the variance between the lowest and highest values[…]
Read moreAuthor: Abu Hasan
Use INDIRECT to Pull Data from Different Worksheets/ Named Ranges
INDIRECT is a Powerful function in Excel. In this post I am going to show you how INDIRECT can be[…]
Read moreFILTER CONNECTS UNRELATED TABLES
One important feature of FILTER function in DAX is that it can establish a relationship between two tables when no[…]
Read moreInformative Charts / Data Visualizations
“All that glitters is not GOLD” Similarly “All Cool Looking Charts are not necessarily Informative Charts” An Informative Chart is[…]
Read moreTennis Dashboard in Excel
Who was better? Federer or Djokovic.. Nadal or Murray ATP uses following Dashboard to compare statistics between the players Although[…]
Read moreDASHBOARDS THAT INTERACT ON MOUSE MOVE
In my earlier post, I showed you how to create Excel Dashboards that interact when a cell is CLICKED or[…]
Read moreZoom Excel Dashboard to Fit Screen Size
I typically have to share my dashboards with a large audience. Some people use them on their laptops and others[…]
Read moreUsing Slicers to Highlight Instead of Filter
The normal behavior of slicer is to filter the associated Pivot Tables and Pivot Charts How can we make Slicers[…]
Read moreCONCATENATEX
CONCATENATEX is a DAX function introduced in Power Pivot for Excel 2016. It wont work in Excel 2013 or 2010[…]
Read moreGROUPING, BANDING, SEGMENTATION BASED ON RANGE OF VALUES
Grouping and Banding makes analysis easier and convenient Consider for example this table of 250 billionaires taken from www.forbes.com/billionaires/list Click[…]
Read more