I’ve run into challenges replicating certain visuals from Power BI. For example many fields—such as “Contract Number”—are stored as text, preventing their use in bar charts. Is there a way to change data types within FDI?
In Calculations you can CAST to a different data type. Or you could create an aggregation…Count(Contract Number)
You can convert to number using Data Prep, at the dataset level, if you are an author and if it's not a subject area.
See below option:
