AXIS COLUMNS DAX Statement
The AXIS COLUMNS keyword defines an axis for the columns of a visual shape for visual calculations.
Find more in Introducing VISUAL SHAPE for visual calculations in Power BI.
The following example shows an example of a visual shape definition in a DAX query.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 | TABLE '__DS0VisualCalcs' = __DS0VisualCalcsInput WITH VISUAL SHAPE AXIS ROWS GROUP [Brand] TOTAL [IsGrandTotalRowTotal] GROUP [Category] , [Category_Code] TOTAL [IsDM1Total] GROUP [Color] TOTAL [IsDM3Total] ORDER BY [Brand] ASC , [Category_Code] ASC , [Category] ASC , [Color] ASC AXIS COLUMNS GROUP [Year] TOTAL [IsGrandTotalColumnTotal] GROUP [Month] , [Month_Number] TOTAL [IsDM6Total] ORDER BY [Year] ASC , [Month_Number] ASC , [Month] ASC DENSIFY "IsDensifiedRow" |
Last update: Mar 8, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo