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...
Add a flag to create index for SCAN and CONTAINSSTRING automatically when the dataset is loaded in memory.
The current optimization for SCAN and CONTAINSSTRING generates an index for ASCII-only text columns at the first request including either SCAN or CONTAINSSTRING. The index build operation could be up to 25 seconds long and goes in timeout if it takes more time. It would be useful to be able to...
Support non ANSII characters in SEARCH and CONTAINSSTRING index
The index for SEARCH and CONTAINSSTRING only supports ASCII characters.
It would be helpful to support non-ASCII characters in two ways:
- Just create the index that supports diacritics (this could be expensive/complex)
- Create the index by using a column that transforms ...