Sorting column headers of matrix visual in descending order in Power BI

Sorting column headers of a matrix visual in descending order in Power BI

August 31, 2021 0

Getting rid of scientific format for decimal numbers in Power BI

If you have ever dealt with decimal numbers with too many decimal places and expose such data in Power BI, you might see them getting automatically formatted in scientific notation. For example, see the below sample data from a csv file: Targets for different teams in a company When you load this data into Power... Continue Reading →

June 29, 2021 1

Displaying non-additive measures in Power BI visuals

May 10, 2021 0

Customized dynamic time matrix visual in Power BI

customized dynamic time matrix in Power BI using DAX

April 5, 2021 0

Hiding and Locking only cells with formulas in Excel

Hiding and locking only those cells/range that have formulas in Microsoft Excel.

April 4, 2021 2

A smarter multi criteria VLOOKUP in Excel

Performing multi-criteria lookup in Excel. The combination of VLOOKUP and CHOOSE functions does the magic elegantly.

March 31, 2021 1

Types of data in analytics

Types of Data in Self-Service BI, Reporting, Analytics and Citizen Data Science

Most analytics learnings start with understanding the types of data. This article gives a holistic view on types of data in self-service BI reporting, analytics, and citizen data science while also embracing the new data types resulted with the advent of big data technologies.