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 ,

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 .