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 (Fis...
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.

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.

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

      Hi Anonymous 

       

      Using a line and stacked-column chart

      Is it because my calendar table is down to days compared to your example only firstday of month? Note, i tried to create a BOM collumn but that an index is duplicated for each day of month, How do i create a summarized of calendar on first day of month only but still linked to main calendar day?

       

      anything more on coll width & legend symbal decrease?

       

      Thank You for helping?