Step 1: Load data to Power BI Desktop Open Power BI desktop Click on use sample data to load sample data to Power BI desktop Click on load sample data to load data to model. Sample data looks like below Step 2 : Create measure table Home à click on enter data under data section Create table as Measure Click on load Have created below 4 measures Profit = SUM ( financials[Profit] ) Sales = SUM ( financials[Sales] ) Units Sold = SUM ( financials[Units Sold] ) Gross Sales = SUM ( financials[Gross Sales] ) Step 3: Create new table for display format Go to modeling tab Click on new table under calculations section and provide below query to new table DisplayFormat = DATATABLE ( "FormatOptions" , STRING , "Sort" , INTEGER , { { "Millions" , 1 }, { "Thousands" , 2 }, { "Original Values" , 3 } ...