Forum Discussion
Custom Format - via Tabular Editor (thousands)
Hi 101Mathew ,
If I understand correctly you are setting the format string expression for the Calculation Item? I believe you need to wrap the expression in quotation marks for calculation items - see Matt Allington's blog post as an example https://exceleratorbi.com.au/dynamic-formatting-of-switch-measures/
Where the expression already has quotation marks in it I've had success replacing them with /. So for some calculation items I've had to go from "£"#,0.00;-"£"#,0.00;"£"#,0.00 to "\£#,0.00;-\£#,0.00;\£#,0.00" - I believe this would work in your example if you put the required amount of decimal places in?
Not sure if that's what you are after
Tom
Hi 101Mathew ,
May be I don't understand your last response properly.
Do you want this with ZERO decimal places?
Add some screenshots to your issue not just the formatting you are looking for. Screenshots sometimes make things clear or may be explain your self again as I don't understand your last response properly.
Thanks,
Pragati
Hi Pragati11 ,
But the below does not show the full intent
Using tabular editor, allows calculation groups within Power BI models - On each element of the calculation group, tabular editor lets you use format scripts
The question is do you get the above, via custom format within tabular editor