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.  

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Sorry for the confusion. These are my hypothetical data, 'Sheet1' is 'InjuryCause', 'Type' is 'Cause Grouping', and 'col2' is the value of 'Ref'. Can you share some simple data?

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 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