Data Bars in a table not working with created measure

[rile14]

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:

Area =

    IF(SELECTEDVALUE('Slicer Imperial Metric System'[Measurement]) in {"Imperial"},

    FORMAT([Total Leasable Area], SWITCH(SELECTEDVALUE('Slicer Imperial Metric System'[Measurement]),"Imperial", "#,##0sqft;(#,##0)sqft")),

    FORMAT([Total Leasable Area], SWITCH(SELECTEDVALUE('Slicer Imperial Metric System'[Measurement]),"Metric", "#,##0sqm;(#,##0)sqm"))

)

With this measure i'm getting desired output, but the issue is that i'm now not able to get data bars displayed.

Does anyone know what is the issue here? Is the above dax correct?

Just to point out that data type is defined as a decimal number.

Thanks in advance.

[AlexisOlson]

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

[rile14]

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.

[AlexisOlson]

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.