Forum Discussion

bdehning's avatar
bdehning
Post Prodigy
2 years ago
Solved

Clustered Column Visual

I have the following visual which uses filter  It is set less than 4 Top 3 by frequency  =   IF (     ISBLANK ( [Count of Total Gross Incurred] ),     BLANK (),     RANKX ( ALL ( InjuryCause[Ca...
Need Help
  • bdehning's avatar
    bdehning
    2 years ago

    I solved the issue by adding both Cause and LOE to my X-Axis.  

bdehning's avatar
bdehning
Post Prodigy
2 years ago
Here is what I am trying but when I use EARLIER('InjuryCause'[Cause Grouping])) 'InjuryCause'[CauseGrouping]  is in red?   Is not not like EARLIER?  Refers to an earlier row context which doesn't exist?
 
Top 3 by frequency =
IF (
    ISBLANK ( [Count of Total Gross Incurred] ),
    BLANK (),
    RANKX (FILTER('InjuryCause', 'InjuryCause'[Cause Grouping] = EARLIER('InjuryCause'[Cause Grouping])),LossRun[Count of Total Gross Incurred],,DESC,Skip)
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi bdehning ,

This function requires a row-context computing environment .Please attempts to create a calculated column, not a measure.

  • bdehning's avatar
    bdehning
    Post Prodigy
    2 years ago

    I solved the issue by adding both Cause and LOE to my X-Axis.  

  • bdehning's avatar
    bdehning
    Post Prodigy
    2 years ago

    I tried to use 'InjuryCause'[Cause Grouping] after EARLIER and it stays red.   Is not 'Sheet1'[Type] not the same on both sides of the =?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi bdehning ,

    I am very sorry for taking you in the wrong direction, let's ignore the ranking issue for a moment, the reason for the blank columns is probably due to the use of the legend.

    In the table visual object, only the top three figures are shown, but in the clustered bar chart, blank columns are shown, which should be due to the use of a legend.

     

    Please follow these steps:

    Use the following DAX expression to create a measure

     

    Measure 2 = 
VAR _a = SELECTEDVALUE('Injury Cause'[Cause])
RETURN SWITCH(TRUE(),
_a = "STF","Red",
_a = "Strain","Blue",
_a = "Struckby","Green",
_a = "Caught between","Yellow")

     

    Setting the color

     

  • bdehning's avatar
    bdehning
    Post Prodigy
    2 years ago

    I realized the Legend was the issue as my table of date is fine.   Unfortunately there are 250 Injury Causes possible, so setting the 4 with color in your measure will not solve this .