Forum Discussion
Yael
Helper IV
8 years agoFE 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!
2 Replies
- v-chuncz-msft
Community Support
- Yael
Helper IV
Thanks v-chuncz-msft