Sorting column headers of a matrix visual in descending order in Power BI
Sorting column headers of 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 →
Share this:
Displaying non-additive measures in Power BI visuals
Displaying non-additive measures in Power BI visuals
Share this:
Customized dynamic time matrix visual in Power BI
customized dynamic time matrix in Power BI using DAX
Share this:
Data Vs Data Points Vs Metrics Vs KPIs
Data Vs Data Points Vs Metrics Vs KPIs. Bringing clarity to chaos.
Share this:
Data Connection, Data Source, Data Set, blah blah blah in the context of Self-Service Analytics & BI – Bringing clarity to chaos.
Few important terms used in the context of self-service analytics and BI tools.
Share this:
Calculating Age (duration or difference between two dates) in years, months and days in Power Query M Script
16-Jul turns out to be the birthday of Microsoft Power BI. Here I post a formula in M Script to calculate the age (i.e., duration or difference between two dates) in years, months and days: let Source= [ PowerBIBDay = #date(2014, 7, 16), Today = Date.From(DateTime.LocalNow()), BirthdayFactor = if Date.DayOfYear(PowerBIBDay)<Date.DayOfYear(Today) then 0 else 1, DayFactor... Continue Reading →
