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

Hi bdehning ,

Regarding your question, I think there may be a problem with the ranking, I created the measure and calculated columns and they both show 1.

You can try modifying it in this format

If I understand you wrong, can you share your .pbix file without sensitive data?

bdehning's avatar
bdehning
Post Prodigy
2 years ago

Hard to share file, which part did you modify with your Rank=?  Was it the Top 3 By Frequency or the Sort Measure?   

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi bdehning ,

    I think we should change it here.

    Assuming that the column 'Cause Grouping' has the values 'No Data','<1yr','yr', and you have cleared the filtering capability of the field using the ALL function, the 'Ref values should all be the same, for sorting all are 1

    • bdehning's avatar
      bdehning
      Post Prodigy
      2 years ago

      I was trying this earlier and trying to figure out What is Sheet1 and Sheet1[Type] and then Col2.   I Assume Sheet1 is Injury Cause and Type is Cause Grouping.  Not sure what Col2 is for me?   Its Either Count of Total Gross Incurred or LossRun[LOE 2023]?

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