BIP Publisher Layout Template Custom Sorting in Bar Graph

ts001

Summary

BIP Publisher Layout Template Custom Sorting in Bar Graph

Content

Guys,

Does anyone has idea of how to do custom sorting in BIP Publisher layout template Bar Graph? Currently it is either doing Asc or Desc alphabetically. But according to my requirement I want to sort according to business requirement.

In my DM SQL I added sort order column according to requirement? But only if I use Data Table option I see data is sorted as per SQL output. But when I use Bar Graph it is sorting alphabetically. I don't want to use sort column in report. As the data is coming as 1-xxxx, 2-xxxxx in labels and Legend.

Ex: Month has to sort Jan, Feb, Mar, not alphabetically or 1-Jan, 2-Feb etc.

Did anyone face this issues? If yes please let me know how you resolved it.

BIP : Oracle BI Publisher 12.2.1.2.0

DB: MySQL

Thanks

ts001

Any work around is appreciated,  Thank you