Forum Discussion

Remco1986's avatar
Remco1986
Icon for Helper I rankHelper I
6 years ago
Solved

Using Measure in chart axis, or make column instead of measure

Hi all, after finding some great info on this forum, here's my first topic. My first part of this problem succeeded because of other topics I found, but I'm now running into an issue that I can not ...
Remco1986's avatar
Remco1986
Icon for Helper I rankHelper I
6 years ago

amitchandak thanks, these links were very usefull.

 

I have now made a table (called 'quartileMap' with the Quartile texts and the sort-order:

quartileNamesortOrder
Quartile 11
Quartile 22
Quartile 33
Outliers4

 

Next, I created a measure:

 

 

Test = 
    SWITCH(SELECTEDVALUE(quartileMap[quartileName]),
        "Quartile 1",   COUNTROWS(filter(SUMMARIZE(ALLSELECTED(myTable),[Employee Name],"Quartile",[Quartile]),[Quartile]="Quartile 1")),
        "Quartile 2",   COUNTROWS(filter(SUMMARIZE(ALLSELECTED(myTable),[Employee Name],"Quartile",[Quartile]),[Quartile]="Quartile 2")),
        "Quartile 3",   COUNTROWS(filter(SUMMARIZE(ALLSELECTED(myTable),[Employee Name],"Quartile",[Quartile]),[Quartile]="Quartile 3")),
        "Outliers",     COUNTROWS(filter(SUMMARIZE(ALLSELECTED(myTable),[Employee Name],"Quartile",[Quartile]),[Quartile]="Outliers"))
    )

 

 

 

I can now create a bar graph with the quartileName from the quartileMap table in the Axis, and the Test measure as values.

 

Only thing is that the Quartile axis is not sorting by sortOrder, but alphabetically, causing Outliers to appear before Quartile 1, 2, 3. Instead of after Quartile 1, 2, 3. Not sure what the sortOrder does in this table. Never mind this last part, I had to select the quartileName column and sort it by sortOrder