Forum Discussion

Post 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
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

Post 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

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
Post 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?