Sorting column headers of a matrix visual in descending order in Power BI
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 →
Displaying non-additive measures in Power BI visuals
Displaying non-additive measures in Power BI visuals
Customized dynamic time matrix visual in Power BI
customized dynamic time matrix in Power BI using DAX
Office Scripts: Is it the beginnings of the end of VBA era?
It has been quite some time now a lot of talk around the future of VBA. Here comes the Office Scripts in Microsoft Office web apps like Excel (in its preview) with two important features to seed the beginnings of the end of VBA era:Â Actions recorder: Mimicking VBA macro recorder functionality Automation scripting: Mimicking... Continue Reading →