# Formatting "Inherited from Modeling" not working in visualization **URL:** \ **Category:** Report Bugs\ **Created:** [January 30, 2024, 3:17pm UTC](https://community.holistics.io/t/formatting-inherited-from-modeling-not-working-in-visualization/1787 "2024-01-30T15:17:47Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Ian\_McLaren](https://community.holistics.io/user_avatar/community.holistics.io/ian_mclaren/32/647_2.png) [@Ian\_McLaren](https://community.holistics.io/u/Ian_McLaren)\ **Post date:** [January 30, 2024, 3:17pm UTC](https://community.holistics.io/t/formatting-inherited-from-modeling-not-working-in-visualization/1787/1 "2024-01-30T15:17:47Z")
Hey I’ve set number formats in a data model (eg `format: "[$$]#,###"`) but it’s not appearing that way in visualizations. Obviously I can go in and set it directly in the visualization but to my mind that defeats the point of pre-setting it in the data model in the first place. One thing, the measures that have the number formats defined are all `aggregation_type: 'custom'`, not sure if that’s a factor… ---
**Author:** ![Toan\_Lam\_Thien](https://community.holistics.io/user_avatar/community.holistics.io/toan_lam_thien/32/1147_2.png) [@Toan\_Lam\_Thien](https://community.holistics.io/u/Toan_Lam_Thien)\ **Post date:** [January 31, 2024, 2:00am UTC](https://community.holistics.io/t/formatting-inherited-from-modeling-not-working-in-visualization/1787/2 "2024-01-31T02:00:07Z")
Hi Ian, Thank you for contacting us. Pertaining to the matter at hand, our team is currently conducting an investigation. It would be greatly beneficial if you could supply the location where you performed the formatting and the screenshot as well. We eagerly anticipate your prompt response. Kind regards, Toan ---
**Author:** ![Ian\_McLaren](https://community.holistics.io/user_avatar/community.holistics.io/ian_mclaren/32/647_2.png) [@Ian\_McLaren](https://community.holistics.io/u/Ian_McLaren)\ **Post date:** [January 31, 2024, 9:36am UTC](https://community.holistics.io/t/formatting-inherited-from-modeling-not-working-in-visualization/1787/3 "2024-01-31T09:36:52Z")
Thanks. The formatting is set in model definition, like: ![image](https://community.holistics.io/uploads/default/original/2X/3/325f49143af34eb97cb397299583724cb9c60b16.png) When I preview it from the model, it looks as expected: ![image](https://community.holistics.io/uploads/default/original/2X/1/1ae4039aba6d2e0a6e0960ad5de67d50b5e9c672.png) When I preview it from a dataset that uses the model, it loses the formatting: ![image](https://community.holistics.io/uploads/default/original/2X/d/dabad5066ce75e0d00ccf3bdd3887251e0716c31.png) This is also how it appears in the prod environment using that dataset: ![image](https://community.holistics.io/uploads/default/original/2X/c/c231627a6a10116c875957d8a92e91ec08995891.png) ---
**Author:** ![Toan\_Lam\_Thien](https://community.holistics.io/user_avatar/community.holistics.io/toan_lam_thien/32/1147_2.png) [@Toan\_Lam\_Thien](https://community.holistics.io/u/Toan_Lam_Thien)\ **Post date:** [February 1, 2024, 2:58am UTC](https://community.holistics.io/t/formatting-inherited-from-modeling-not-working-in-visualization/1787/4 "2024-02-01T02:58:36Z")
Hi Ian, Thank you for your response and for the insights provided by you. With respect to the matter at hand, we have attempted to recreate the issue but to no avail. Could you possibly confirm whether you saved your modifications during the measure definition process in the data model? If that was indeed the case, it would be necessary for us to impersonate to comprehensively investigate the underlying cause. We anticipate your prompt response on this matter. Kind regards, Toan ---
**Author:** ![Ian\_McLaren](https://community.holistics.io/user_avatar/community.holistics.io/ian_mclaren/32/647_2.png) [@Ian\_McLaren](https://community.holistics.io/u/Ian_McLaren)\ **Post date:** [February 1, 2024, 9:20am UTC](https://community.holistics.io/t/formatting-inherited-from-modeling-not-working-in-visualization/1787/5 "2024-02-01T09:20:05Z")
Yes, I’ve saved changes to the data model and even deployed it to production. Happy to have you guys having a look in our Holistics instance to see if you can figure out what’s going on, should I raise a support ticket or can you do it from the info I’ve provided? ---
**Author:** ![Toan\_Lam\_Thien](https://community.holistics.io/user_avatar/community.holistics.io/toan_lam_thien/32/1147_2.png) [@Toan\_Lam\_Thien](https://community.holistics.io/u/Toan_Lam_Thien)\ **Post date:** [February 1, 2024, 10:30am UTC](https://community.holistics.io/t/formatting-inherited-from-modeling-not-working-in-visualization/1787/6 "2024-02-01T10:30:32Z")
Hi Ian, Could you provide us with your email that used Holistics and the data model, and the dataset link you previewed as well? Looking forward to hearing from you soon! Best regards, Toan ---
**Author:** ![Toan\_Lam\_Thien](https://community.holistics.io/user_avatar/community.holistics.io/toan_lam_thien/32/1147_2.png) [@Toan\_Lam\_Thien](https://community.holistics.io/u/Toan_Lam_Thien)\ **Post date:** [February 1, 2024, 10:33am UTC](https://community.holistics.io/t/formatting-inherited-from-modeling-not-working-in-visualization/1787/7 "2024-02-01T10:33:32Z")
Hi Ian, Please provide this information by raising a support ticket. Best regards, Toan ---
**Author:** ![mpyper](https://community.holistics.io/user_avatar/community.holistics.io/mpyper/32/1513_2.png) [@mpyper](https://community.holistics.io/u/mpyper)\ **Post date:** [February 6, 2024, 11:44pm UTC](https://community.holistics.io/t/formatting-inherited-from-modeling-not-working-in-visualization/1787/8 "2024-02-06T23:44:03Z")
I’m also seeing this behaviour, but only on datasets using the AQL engine ` __engine__ : 'aql'`. Reverting to ` __engine__ : 'sql'` brings the formatting back. ---
**Author:** ![Duong\_Ly](https://community.holistics.io/letter_avatar_proxy/v4/letter/d/d26b3c/32.png) [@Duong\_Ly](https://community.holistics.io/u/Duong_Ly)\ **Post date:** [February 7, 2024, 7:47am UTC](https://community.holistics.io/t/formatting-inherited-from-modeling-not-working-in-visualization/1787/9 "2024-02-07T07:47:59Z")
Hi @mpyper, @Ian_McLaren and anyone who might concern, Upon investigation, we acknowledge this as a system bug and are actively working on resolving the problem. We sincerely apologize for any inconvenience caused and will keep you updated on the progress of handling this issue. ---
**Author:** ![mpyper](https://community.holistics.io/user_avatar/community.holistics.io/mpyper/32/1513_2.png) [@mpyper](https://community.holistics.io/u/mpyper)\ **Post date:** [February 27, 2024, 4:32pm UTC](https://community.holistics.io/t/formatting-inherited-from-modeling-not-working-in-visualization/1787/10 "2024-02-27T16:32:20Z")
Hi, any updates on this? It’s quite frustrating to have to go through the custom formatting steps for every field in a visualisation, especially when it’s a non-USD currency amount (seven clicks to go through all the menus! More to remove the decimals) ---
**Author:** ![Khai\_To](https://community.holistics.io/user_avatar/community.holistics.io/khai_to/32/128_2.png) [@Khai\_To](https://community.holistics.io/u/Khai_To)\ **Post date:** [March 3, 2024, 2:24pm UTC](https://community.holistics.io/t/formatting-inherited-from-modeling-not-working-in-visualization/1787/12 "2024-03-03T14:24:55Z")
Hi @Ian_McLaren and @mpyper, We have released the fix for this error. Could you check if this issue persists on your end? ---
**Author:** ![Ian\_McLaren](https://community.holistics.io/user_avatar/community.holistics.io/ian_mclaren/32/647_2.png) [@Ian\_McLaren](https://community.holistics.io/u/Ian_McLaren)\ **Post date:** [March 4, 2024, 10:02am UTC](https://community.holistics.io/t/formatting-inherited-from-modeling-not-working-in-visualization/1787/13 "2024-03-04T10:02:41Z")
No, it doesn’t look any different to me. The set format doesn’t appear when I’m querying the dataset or in visualizations. ---
**Author:** ![dat.cv](https://community.holistics.io/user_avatar/community.holistics.io/dat.cv/32/876_2.png) [@dat.cv](https://community.holistics.io/u/dat.cv)\ **Post date:** [March 12, 2024, 11:20am UTC](https://community.holistics.io/t/formatting-inherited-from-modeling-not-working-in-visualization/1787/14 "2024-03-12T11:20:12Z")
Hey @Ian_McLaren, I’m sorry for any inconvenience you may have experienced. To ensure we can provide you with the best assistance possible, would you mind submitting a support ticket with the links to the data models and datasets you’re working with? I’m looking forward to hearing from you soon. ---
**Author:** ![mpyper](https://community.holistics.io/user_avatar/community.holistics.io/mpyper/32/1513_2.png) [@mpyper](https://community.holistics.io/u/mpyper)\ **Post date:** [March 14, 2024, 3:11pm UTC](https://community.holistics.io/t/formatting-inherited-from-modeling-not-working-in-visualization/1787/15 "2024-03-14T15:11:34Z")
Just to confirm, this fix _did_ work for me, it looks like it may be a different issue that Ian is experiencing in which case apologies for piggybacking off the original bug report. ---
**Author:** ![Ian\_McLaren](https://community.holistics.io/user_avatar/community.holistics.io/ian_mclaren/32/647_2.png) [@Ian\_McLaren](https://community.holistics.io/u/Ian_McLaren)\ **Post date:** [March 14, 2024, 4:58pm UTC](https://community.holistics.io/t/formatting-inherited-from-modeling-not-working-in-visualization/1787/16 "2024-03-14T16:58:43Z")
Just been having another look at it, I think I’m good now. I’m setting the format in the metric definition and it’s working fine. If I have any other issues I’ll come back to you.