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 All,
I have a slicer where I can select between Imperial and Metric values. Currently I have area values in the table displayed without sqm/sqft, just pure numbers. I have created this measure in order to get sqm/sqft displayed together with those amounts from the column:
Yeah, data bars aren't going to work with text output. Luckily, you can keep the measure a numeric data type and still set a custom format for it.
In the Model pane select the measure and set Format to custom and set the format string here:
I used this format string:
#,0\s\q\m
Thanks for your response @AlexisOlson
I assume you didn't apply this format to my measure, but on a clean number field?
When I try to use this custom format with my measure from above, it doesn't work.
If I apply this format to a measure that is showing just a number, then it works, but it's not what I need.
I need this to be dynamic, so when I select 'Imperial' from the slicer I expect to see SQFT and when I select 'Metric' I expect to see SQM. Because of that I created a measure that I written above.
Does it mean that it's not possible to have data bars withs such measure?
Thanks.
That's correct. I applied it to a clean number field.
It's a bit trickier if you need multiple custom formats but I was able to do leveraging the Format String Expression within a calculation group.
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |