FE formatting options when connecting live to Tabular

[Yael]

 Hello,

I'm connecting live to tabular model, and have 2 questions regarding formatting options on PBI Desktop:

1. Is there a way to change the sorting of values in a field? 

For Example: I have a field called "Number of Instances" with values 1,2,3,No instances. The order of vales displayed in legend, slicer and so on is: 1,2,3, No instances. But what I would like to see is: No instances, 1, 2, 3.

Is there a way to do this?

2. When creating measures and adding them to a table: is there a way to display zeros instead of blanks?

The DAX I'm using is this:

Measure = 
CALCULATE(
                  COUNTA(field),
                 field=1
                   )

Thank you!

[v-chuncz-msft · Accepted solution]

@Yael,

You may check Column Properties Sort By Column and add zero (+ 0) to the DAX formula.

[Yael]

Thanks @v-chuncz-msft