{"id":23654,"date":"2018-08-12T05:45:35","date_gmt":"2018-08-12T05:45:35","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=23654"},"modified":"2018-09-11T18:05:24","modified_gmt":"2018-09-11T12:35:24","slug":"power-bi-data-category","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/power-bi-data-category\/","title":{"rendered":"Power BI Data Category | Set Power BI Geographic Filter"},"content":{"rendered":"

1. Objective
\n<\/span><\/h2>\n

In our last session, we discuss the Power BI Ribbon Chart<\/strong><\/a>. Here, in this Power BI tutorial, we will learn Power BI Data Category and how to set Power BI Geographic filter in Power BI Desktop for the mobile apps. Moreover, we will study recognition, making and viewing of geographic information in your\u00a0report.
\nSo, let’s start Power BI<\/a><\/strong> Data Category Tutorial.<\/p>\n

\"Power<\/a>

Power BI Data Category | Set Power BI Geographic Filter<\/p><\/div>\n

2. Data Categorization in Power BI Desktop<\/h2>\n

In Power BI Desktop, you can determine the Data Category for a section so Power BI Desktop knows how it should treat its qualities when in a representation.
\nAt the point when Power BI Desktop imports information, not exclusively does it get the information itself, it likewise gets data. For example, the table and section names, regardless of whether it’s an essential key, and so on. With that data, Power BI Desktop makes a few presumptions about how to give you a decent default encounter while making a perception.
\nDo you know about Power BI Data Modeling?<\/a><\/strong>
\nHere’s an illustration:<\/strong> When Power BI Desktop distinguishes a segment has numeric qualities, you’ll most likely need to total it somehow. So it’s set in the values zone. Then again, for a section with date time esteems, it accept you’ll most likely utilize it as a period order hub on a line diagram.
\nBe that as it may, there are a few cases that are more testing, similar to geology. Think about the accompanying table from an Excel worksheet:
\nShould Power BI Desktop treat the codes in the GeoCode section as a truncation for a Country or a US State? It’s not clear on the grounds that a code like this can mean it is possible that one.
\nFor example,
\n AL<\/strong> can mean Alabama<\/em> or Albania.<\/em>
\nAR<\/strong> can mean Arkansas<\/em> or Argentina.<\/em>
\nCA<\/strong> can mean California<\/em> or Canada<\/em>.
\nIt has any kind of effect when we go to diagram our GeoCode field on a guide. Should Power BI Desktop demonstrate a photo of the world with nations featured or a photo of the United States with states featured? You can determine a Power BI Data Category for information simply like this. Information order additionally refines the data Power BI Desktop can use to give the best perceptions.<\/p>\n

3. How to Determine Power BI Data Category?<\/h2>\n

In Report View or Data View, in the Fields list, select the field you need to arrange by an alternate order.<\/p>\n