How to restrict some columns not to format

Hello, Ravi!
 
Thank you for reaching out to us.
 
Kindly note that the number formatting pop-up we provide as a part of the Toolbar is designed to show all existing measures. If you want some measures to be hidden in the dropdown, we suggest creating a custom number formatting pop-up instead of the built-in one.
 
The algorithm is the following:
 
1. Add a new tab to the Toolbar using the beforetoolbarcreated event.
Here is the JSFiddle example with adding a new tab: https://jsfiddle.net/flexmonster/m7e74ay4/.
You can find more details about customizing the Toolbar in our docs: https://www.flexmonster.com/doc/customizing-toolbar/.
 
2. (optional) Remove the existing 'Number formatting' tab from the submenu.
We have prepared the JSFiddle example for visualization: https://jsfiddle.net/flexmonster/2nqLxfrk/.
 
3. Create your own pop-up for number formatting, where you can prefilter fields with percentages before displaying the drop-down.
You can look through the flexmonster/toolbar/flexmonster.toolbar.js file with our Toolbar source code for references. The main pop-up functionality for number formatting can be found in the FlexmonsterToolbar.prototype.showFormatCellsDialog function.
 
Hope you will find our answer helpful.
Feel free to ask if any further questions arise.
 
Regards,
Solomiia

Hello, Ravi!

Hope you are having a great week.

Our team is wondering if you had some time to try the suggested approach of making the custom number formatting pop-up. Could you please let us know if it works for your case?

Feel free to ask if any further questions arise.

Best regards,
Solomiia

Hello, Ravi!
 
Hope you are doing well.
 
Just checking in to ask if the approach of making custom number formatting pop-up works for your case.
 
Feel free to contact us in case of any other questions.
 
Best regards,
Solomiia