Matrix/tables should display KPI of a Tabular model like Excel
The KPI defined in a Tabular model are displayed in a different way in Power BI compared to Excel. - Excel supports decimal numbers from -1 to 1 for both 3 and 5 states graphics - Power BI supports integer numbers from -2 to 2 for 5-states graphics, and integer numbers from -1 to 1 for 3-states g...
Define query calculation items in calculation groups
Enable a syntax to define/replace a calculation item of a calculation group in a DAX query. DEFINE CALCULATIONITEM 'Time Intelligence'[Time Calc]."YTD" = CALCULATE ( SELECTEDMEASURE(), DATESYTD ( DimDate[Date] ) )
Dictionary for colors of data series
The colors applied to data series is based on current template. However, it's frequent to have specific colors for categories / products / regions. A useful tool would be the ability to generate a "dictionary" of colors associated to terms/names found in data series. Importing the dictionary in a...