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.
I'm using a measure in a matrix, and for some reason the value is showing the subtraction operator (see the attached image - none of these values are negative, that's the operator). This makes the visual unusuable. How do I remove it? Thanks!
Solved! Go to Solution.
If you want it to always show a postive number regardless of the output, just convert it to an absolute value. Wrap your measure in =ABS()
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThe result of subtracting the MaxYear from MinYear is resulting in negative numbers. The visual isn't showing the operator. It is showing results of the math.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThank you for your suggestion! The result of the function is displayed in the 'Total' field (which can be negative) - the data in the date rows will never be negative.
.
If I remove the variable filter and shorted it to a CONCATENATE(SUM - SUM) the minus operator goes away, but for some reason when I'm doing a CONCATENATE(SUM,var) - CONCATENATE (SUM,var) the operator is present in the output.
If you want it to always show a postive number regardless of the output, just convert it to an absolute value. Wrap your measure in =ABS()
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThanks Ed, that worked.
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 |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |