Month Char

[gautik92]

I have a bar chart with two expressions showing values for max month and max(Month)-variable

in legend i want to show the name of the month

how can i achieve this?

Now its show no of month

[gautik92]

It dint work Stephenedberkg‌

[#3]

Following script will resolve

MapTable:

Mapping LOAD

RowNo() as MonthID,

Month(AddMonths((Today()),RowNo()+7)) as MonthName

AutoGenerate 12;

FactTable:

LOAD *, ApplyMap('MapTable',MonthID) as MonthName

Inline [

MonthID

1

2

3

4

5

6

7

8

9

10

11

12

];

[gardenierbi]

See attachment, do you mean something like this?

[gautik92]

i askd for legends not dimesions

[gardenierbi · Accepted solution]

Works the same! See attachment!

[sasiparupudi1]

use the expressions

=Month(MakeDate(year(Today(1)),max(Month)))

and

=Month(MakeDate(year(Today(1)),max(Month)-1))

for your labels in your chart

hth

Sasi

[gautik92]

Excellent!!!! Thanks GardenierBI