Need Help!!! Slicer element formatting

Anonymous — Wed, 15 Nov 2017 15:12:36 GMT

Hi All,

I have a date format in my report from which i have extraced month to use as a slicer. i have made a calculated column from that extracted month column like below-:

=(if [Report Month]=1 then "January" else
if [Report Month]=2 then "February" else
if [Report Month]=3 then "March" else
if [Report Month]=4 then "April" else
if [Report Month]=5 then "May" else
if [Report Month]=6 then "June" else
if [Report Month]=7 then "July" else
if [Report Month]=8 then "August" else
if [Report Month]=9 then "September" else
if [Report Month]=10 then "October" else
if [Report Month]=11 then "November" else
"December")

but the slicer is displaying month names like this-:

Can anyone tell how we can dispplay month names as calender type like

Jan

Feb

Mar

April....

and not in alphabetical order?

Regards,

Droid

Re: Need Help!!! Slicer element formatting

Eric_Zhang — Thu, 16 Nov 2017 07:46:21 GMT

@Anonymous

You need to create an auxiliary table and relationship as below, then click on the month column and sort it by sequence.

Re: Need Help!!! Slicer element formatting

Anonymous — Fri, 17 Nov 2017 05:50:56 GMT

@Eric_Zhang, Thank you Eric. That worked like Charm. 🙂

topic Re: Need Help!!! Slicer element formatting in Developer

Need Help!!! Slicer element formatting

Re: Need Help!!! Slicer element formatting

Re: Need Help!!! Slicer element formatting