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