Sort chart with null values

SwenWa — Sat, 16 Nov 2024 01:44:25 GMT

Hi team,

I created a bar chart with 1 measure: count(distinct [Number])+0*count({1}distinct [Number])

This formula gives me a "0" for all attributes that normally would not be shown. this works fine for me.

BUT i also want a hardcoded sorting for the attributes (dimension Status).
I tried and failed these 2 possiblities in "sort by expression":

if([Status]='Attr1',1, if([Status]='Attr2',2, if([Status]='Attr3',3, if([Status]='Attr4',4, 100))))
match (Status, 'Attr1','Attr2','Attr3,'Attr4')

Does anyone has an idea how to solve it?

Thanks
Swen

topic Sort chart with null values in App Development