Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
You may check Column Properties Sort By Column and add zero (+ 0) to the DAX formula.
You may check Column Properties Sort By Column and add zero (+ 0) to the DAX formula.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |