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.
Hi there.
When building a report, I had a number of values within the dataset that varied - some percentages, some decimals, others whole numbers. The only way that I could manage to get to display them all in a matrix was to use some SWITCH Dax...
Now I have found that because the Measure is formatted as Text, I'm unable to drop that Measure into the Value field of any chart.
When I try to drop in the original value, then generally incorrect values are output, as these were all decimals. So in the DAX example above,
'Guardian Score' outputs as a decimal, rather than a percentage.
What I need to be able to do is hopefully drop in a Measure to a value field that outputs the formats in the DAX above - can anyone advise a way of amending the DAX to achieve this, or suggest another method that would achieve the same result.
Example of how this is displayed in a matrix..
@Anonymous Once formatted as Text, you won't be able to use it in a Value field well of many visuals as those need to be numeric or an aggregation of a text column (first, etc.). Perhaps try custom format strings. All the formatting, none of the "change to text": https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
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 |
---|---|
47 | |
24 | |
20 | |
14 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |