Problem of sorting on « KPI Grid by MAQ Software »

[SCariniECO]

Problem of sorting on « KPI Grid by MAQ Software »

When we use KPI Grid by MAQ Software,

On category Data we put 2 (or more ) levels , for example in first “group” / in second “society”

On measure data we put Revenue

And we sort by Revenue (Z=>A)

I would like that the “sort by revenue” done on the highest level ( on my example by Group, like that :

level1-Group	Revenu level 1	level2_society	Revenu level2
GroupA	150	society1	100
society2	50
GroupB	130	society3	130
GroupC	90	society4	90

But in powerBi, sorting is done on the lowest level (society), like that

level1-Group	Revenu level 1	level2_society	Revenu level2
GroupB	130	society3	130
GroupA	150	society1	100
society2	50
GroupC	90	society4	90

I think it’s a problem,

What’s your solution ?

[v-qiuyu-msft]

Hi @SCariniECO,

The KPI Grid by MAQ Software visual is authored by MAQ LLC, I would suggest you contact the author for the help as suggested here: https://maqsoftware.com/contact

Best Regards,
Qiuyun Yu 

[MAQSupport]

Hello @SCariniECO,

The Power BI feature of sorting, sorts the granular level data. This is an expected behaviour.

We have added your request 'to sort on the highest level through the visual' to our backlog.

We will notify you when we have this enhancement in the upcoming versions of KPI Grid by MAQ Software.

Thanks