Create a physical table from a virtual one
When a table is virtual i.e. the result of a formula, there are times when one would want it real i.e. as data coming from a query, so that all the facilities related to queries (Transform etc.) are available. This should be obviously and option.
Format the the display of the selected value point on the X axis in a Scatter chart
the value of the current point on the X axis is displayed in an incontrollable size on the chart
Sort order of Drop down list
Ability to sort a drop down list or a list in a slicer by another field value: display a Region Slicer sorted by number of People in each region
Display calculated cluster values on table
Clustering works fine. However the generated fields are showing up empty on the data view. (They display well on a table report)
Export the table visual to a data table
It may sound stupid because if you know DAX you don't need it, but if you start, what great help it would be to export the result of the Visual Table as a data table including the syntax that created it: what a way to quickly achieve results and learn in a fun way
Moving average with QUick Measures
Name: Moving Average per category Description: Calculate the moving average of the base value within the category over 12 months Parameters: Name: Base value Tooltip: The value over which you want to calculate the moving average over 12 months Type: Numerical field / measure Name: Date Tooltip:...