Meeasure Formating in a Lakehouse Semantic Model

Hi debiagui ,

Based on your description, it appears that you are having difficulty applying thousands separators, decimal places, and custom formatting to metric values in Lakehouse. I would like to offer the following steps to troubleshoot and resolve the issue:

1. Ensure that you are using the appropriate tool to set the formatting of the metric values. Formatting is typically done in a reporting tool such as Power BI Desktop, not in Lakehouse itself.
2. Open the Power BI report connected to Lakehouse. Click the metric you want to format. You should be able to select the desired format from the Format drop-down menu. After selecting the format, you can specify the use of thousands separators and set the number of decimal places.
3. If these options are available and effective in the data mart, but do not work in Lakehouse, it may be an indication that the Lakehouse semantic model needs to be restricted or a different approach taken.

If the above steps do not resolve your issue, it would be helpful if you could provide additional details, such as the version of Power BI Desktop you are using, or any error messages that appear when trying to set the metric value format.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.