Forum Discussion

icassiem's avatar
icassiem
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Calculated Column Date Format for X-Axis "MMM" over Fiscal Year & Decrease bar width

Hood day,

 

I am battling for space on a KPI scorecard

1. I would like to make the x-axis only "MMM" = Jan, I have the calculated column and sorted with the month number but it's across years (Fiscal), and then sorting goes bad, the best I can get is MMMYY, not really what I want? 

2. Stacked line column chart, I have limited space but is there a way to make columns narrow, i have the col gaps down to like 1% and max cat height but I cant change the width as my scorecard is maxed and I get a scroll bar which is not going to work?

 

Please Any ideas?

 

Regards

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi icassiem 

     

    Please consider add a new sort column:

    Here i create a set of sample:

    Add a sort column and a format column:

    Sort the Format Column:

    Then add a visual like this:

     

    About the question 2:

    You can change the width this way:

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi icassiem 

     

    Please consider add a new sort column:

    Here i create a set of sample:

    Add a sort column and a format column:

    Sort the Format Column:

    Then add a visual like this:

     

    About the question 2:

    You can change the width this way:

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • icassiem's avatar
      icassiem
      Icon for Post Prodigy rankPost Prodigy
      2 years ago

      Thank You Anonymous 

      1. I keep getting errors as it sees the format coll as having multiple Index values (changed index to number data type), what am i doing wrong the year overlapping is causing issues?

       2. I have it 20 and i can't move the frame more as all the KPI scorecards' widths are fixed, i can get the last 2 months displayed

       

      3. A bit off topic, is there a way to alter the style or make the symbols smaller of the legend?

      Please Any Ideas?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi icassiem 

         

        That's because the sort column shouldn't have duplicate values.

         

         

        Which visual are you using?

        Please indicate it for me.

         

        Best Regards

         

        Zhengdong Xu
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.