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

[icassiem]

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

[v-zhengdxu-msft · Accepted solution]

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]

Thank You @v-zhengdxu-msft 

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?

[v-zhengdxu-msft]

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]

Hi @v-zhengdxu-msft 

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?