{"id":75,"date":"2026-02-25T08:43:20","date_gmt":"2026-02-25T08:43:20","guid":{"rendered":"https:\/\/gigz.pk\/powerbi\/?post_type=lesson&#038;p=75"},"modified":"2026-03-16T04:41:46","modified_gmt":"2026-03-16T04:41:46","slug":"data-types-formatting","status":"publish","type":"lesson","link":"https:\/\/gigz.pk\/powerbi\/lesson\/data-types-formatting\/","title":{"rendered":"Data Types &amp; Formatting"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p>Understanding data types and formatting is essential in Power BI because it ensures that data is interpreted correctly and calculations are accurate. Power BI provides options to define, change, and format data according to its type.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>What are Data Types<\/strong><\/h2>\n\n\n\n<p>A data type specifies the kind of data a column contains. Common data types in Power BI include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Text<\/strong>: Letters, words, or alphanumeric characters.<\/li>\n\n\n\n<li><strong>Whole Number<\/strong>: Integer values without decimals.<\/li>\n\n\n\n<li><strong>Decimal Number<\/strong>: Numbers with decimal points.<\/li>\n\n\n\n<li><strong>Date\/Time<\/strong>: Dates, times, or both.<\/li>\n\n\n\n<li><strong>Boolean<\/strong>: True\/False values.<\/li>\n\n\n\n<li><strong>Currency<\/strong>: Monetary values with currency symbols.<\/li>\n<\/ul>\n\n\n\n<p>Setting the correct data type ensures that Power BI can perform calculations, aggregations, and visualizations accurately.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Changing Data Types<\/strong><\/h2>\n\n\n\n<p>To change a column\u2019s data type in Power BI:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open <strong>Power Query Editor<\/strong> or <strong>Data View<\/strong> in Power BI Desktop.<\/li>\n\n\n\n<li>Select the column you want to modify.<\/li>\n\n\n\n<li>Go to the <strong>Transform tab<\/strong> in Power Query or <strong>Column tools<\/strong> in Data View.<\/li>\n\n\n\n<li>Choose the appropriate <strong>Data Type<\/strong> from the dropdown menu.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Formatting Data<\/strong><\/h2>\n\n\n\n<p>Formatting adjusts how data is displayed without changing the underlying value. Common formatting options include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Number formatting<\/strong>: Set decimal places, thousand separators, or display as percentage.<\/li>\n\n\n\n<li><strong>Date formatting<\/strong>: Show dates in different styles like dd\/mm\/yyyy, mm\/dd\/yyyy, or Month-Year.<\/li>\n\n\n\n<li><strong>Currency formatting<\/strong>: Add currency symbols like $, \u20ac, or PKR.<\/li>\n\n\n\n<li><strong>Text formatting<\/strong>: Capitalize, lowercase, or trim text for consistency.<\/li>\n<\/ul>\n\n\n\n<p>Formatting improves the readability of reports and ensures data is presented clearly in visuals.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Best Practices<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Always check and set the correct data type after importing data.<\/li>\n\n\n\n<li>Use consistent formatting across similar columns to avoid confusion.<\/li>\n\n\n\n<li>Apply formatting before building visuals to ensure numbers, dates, and text display correctly.<\/li>\n\n\n\n<li>Combine data types and formatting with data cleaning for accurate and professional dashboards.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Conclusion<\/strong><\/h2>\n\n\n\n<p>Understanding and applying data types and formatting in Power BI ensures accurate calculations, effective reporting, and visually clear dashboards. Correct data types combined with proper formatting make your data reliable, consistent, and ready for analysis.<\/p>\n\n\n<div class=\"yoast-breadcrumbs\"><span><span><a href=\"https:\/\/gigz.pk\/powerbi\/\">Home<\/a><\/span> \u00bb <span class=\"breadcrumb_last\" aria-current=\"page\">Power BI Fundamentals > Data Import &#038; Transformation > Data Types &#038; Formatting<\/span><\/span><\/div>\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1773636208928\"><strong class=\"schema-faq-question\"><\/strong> <p class=\"schema-faq-answer\"><\/p> <\/div> <\/div>\n","protected":false},"menu_order":13,"template":"","class_list":["post-75","lesson","type-lesson","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Data Types &amp; Formatting - Power BI Learning Hub<\/title>\n<meta name=\"description\" content=\"Learn Power BI data types and formatting to ensure accurate calculations, clean datasets, and clear data visualization in reports.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/gigz.pk\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Types &amp; Formatting - Power BI Learning Hub\" \/>\n<meta property=\"og:description\" content=\"Learn Power BI data types and formatting to ensure accurate calculations, clean datasets, and clear data visualization in reports.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/gigz.pk\/\" \/>\n<meta property=\"og:site_name\" content=\"Power BI Learning Hub\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-16T04:41:46+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\\\/\\\/gigz.pk\\\/powerbi\\\/lesson\\\/data-types-formatting\\\/\",\"url\":\"https:\\\/\\\/gigz.pk\\\/\",\"name\":\"Data Types &amp; Formatting - Power BI Learning Hub\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/gigz.pk\\\/powerbi\\\/#website\"},\"datePublished\":\"2026-02-25T08:43:20+00:00\",\"dateModified\":\"2026-03-16T04:41:46+00:00\",\"description\":\"Learn Power BI data types and formatting to ensure accurate calculations, clean datasets, and clear data visualization in reports.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/gigz.pk\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/gigz.pk\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/gigz.pk\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/gigz.pk\\\/powerbi\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI Fundamentals > Data Import & Transformation > Data Types & Formatting\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/gigz.pk\\\/powerbi\\\/#website\",\"url\":\"https:\\\/\\\/gigz.pk\\\/powerbi\\\/\",\"name\":\"Power BI Learning Hub\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/gigz.pk\\\/powerbi\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Types &amp; Formatting - Power BI Learning Hub","description":"Learn Power BI data types and formatting to ensure accurate calculations, clean datasets, and clear data visualization in reports.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/gigz.pk\/","og_locale":"en_US","og_type":"article","og_title":"Data Types &amp; Formatting - Power BI Learning Hub","og_description":"Learn Power BI data types and formatting to ensure accurate calculations, clean datasets, and clear data visualization in reports.","og_url":"https:\/\/gigz.pk\/","og_site_name":"Power BI Learning Hub","article_modified_time":"2026-03-16T04:41:46+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["WebPage","FAQPage"],"@id":"https:\/\/gigz.pk\/powerbi\/lesson\/data-types-formatting\/","url":"https:\/\/gigz.pk\/","name":"Data Types &amp; Formatting - Power BI Learning Hub","isPartOf":{"@id":"https:\/\/gigz.pk\/powerbi\/#website"},"datePublished":"2026-02-25T08:43:20+00:00","dateModified":"2026-03-16T04:41:46+00:00","description":"Learn Power BI data types and formatting to ensure accurate calculations, clean datasets, and clear data visualization in reports.","breadcrumb":{"@id":"https:\/\/gigz.pk\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/gigz.pk\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/gigz.pk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/gigz.pk\/powerbi\/"},{"@type":"ListItem","position":2,"name":"Power BI Fundamentals > Data Import & Transformation > Data Types & Formatting"}]},{"@type":"WebSite","@id":"https:\/\/gigz.pk\/powerbi\/#website","url":"https:\/\/gigz.pk\/powerbi\/","name":"Power BI Learning Hub","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/gigz.pk\/powerbi\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/gigz.pk\/powerbi\/wp-json\/wp\/v2\/lesson\/75","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gigz.pk\/powerbi\/wp-json\/wp\/v2\/lesson"}],"about":[{"href":"https:\/\/gigz.pk\/powerbi\/wp-json\/wp\/v2\/types\/lesson"}],"wp:attachment":[{"href":"https:\/\/gigz.pk\/powerbi\/wp-json\/wp\/v2\/media?parent=75"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}