Forum Discussion

bdehning's avatar
bdehning
Post Prodigy
1 year ago

Published Power Bi Visual Column Chart randomly loses multiple X-Axis

I have a dashboard with 9 clustered column charts and ocasionally one will lose its sorting and two level X-Axis?.        Why does this happen?
Need Help
bdehning's avatar
bdehning
Post Prodigy
1 year ago

So what your saying is that I could list all years choices which in this case would be <1 yr, 1 yr, 2 yrs, 3 yrs, 4 yrs, 5 yrs, 6-7 yrs, 8-9 yrs, 10-11 yrs, 12-14 yrs, 15-19 yrs, 20-25 yrs and 26+ yrs.   I would have 13 rows of possible. The index would have 1- 13 choices and I could still sort and get the TOP 3 I am looking for?   

 

I need to do some work to take my large PBIX file and remove all sensitive data, but yet leave enough sample data to provide and show my issue for troubleshooting and testing.   

bdehning's avatar
bdehning
Post Prodigy
1 year ago

My columns for each visual are in one main table with a couple from other connected tables.  How do create Index Column and assign my 13 choices for Years choices from 1-13?  so it applies to all rows of large table of data?

  • bdehning's avatar
    bdehning
    Post Prodigy
    1 year ago

    This is the Measure I have to sort by now to get by Top 3 and Top3?  I tried using a Sort Column with Index but I got more than 3 results?

     

    Sort measure Count Location Address1 Cause Sum =
    VAR _FreqByCity = CALCULATE([Count of Total Gross Incurred], FILTER(ALL(InjuryCause[Cause Grouping]), [Top 3 by frequency]<4))
    VAR _LN = LEN(FORMAT(CALCULATE([Count of Total Gross Incurred], ALL('LossRun'[Reporting Location Address1])), "text"))
    VAR _Pre = _FreqByCity *POWER(10, _LN*2)
    VAR _Inc = CALCULATE(RANKX(ALLSELECTED(LossRun[Reporting Location Address1]), [Sum of Total Gross Incurred],,ASC,Dense), ALLSELECTED(InjuryCause[Cause Grouping]))
    VAR _Mid = _Inc * POWER(10, _LN)
    RETURN
    IF(ISBLANK([Count of Total Gross Incurred]), BLANK(), _Pre + _Mid + RANKX(ALLSELECTED(InjuryCause[Cause Grouping]),[Ref],,ASC,Skip))