Forum Discussion

Yael's avatar
Yael
Icon for Helper IV rankHelper IV
8 years ago
Solved

FE formatting options when connecting live to Tabular

 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!