Pro DAX with Power BI by Philip Seamark & Thomas Martens

Author:Philip Seamark & Thomas Martens
Language: eng
Format: epub
ISBN: 9781484248973
Publisher: Apress

Sorting of the Other member using a tooltip

Depending on the number provided as Top N criteria, the dynamically calculated value that represents the remaining Sales Territories, the Other member appears on the top, somewhere in between or at that bottom. This depends solely on the number of Sales Territories selected by the parameter value. This behavior can be exactly what the users of the report are looking for. But it can also be possible that the axis value representing Other always has to appear at the bottom of the bar chart.

This can be achieved by defining a simple measure, simple in comparison to the last. The measure vizAid sort rank is used to ensure that the axis value Other will always appear at the bottom of the chart. Listing 8-8 the DAX statement of this measure.vizAid sort rank =

var NoOfParameter = [No of Sales Territories Value]

var tableSelectedSalesTerritories = VALUES('Dimension City'[Sales Territory])

var tableWithRanks =

FILTER(

ADDCOLUMNS(

tableSelectedSalesTerritories

,"rank",[_Rank]

)

,[rank] <= NoOfParameter

)

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.