Avvenimenti
Kampjonati tad-Dinja Power BI DataViz
Feb 14, 4 PM - Mar 31, 4 PM
B'4 ċansijiet biex tidħol, tista 'tirbaħ pakkett ta' konferenza u tagħmilha għall-Grand Finale LIVE f'Las Vegas
Sir af aktarDan il-brawżer m'għadux appoġġjat.
Aġġorna għal Microsoft Edge biex tieħu vantaġġ mill-aħħar karatteristiċi, aġġornamenti tas-sigurtà, u appoġġ tekniku.
APPLIES TO:
Power BI Desktop
Power BI service
When Power BI Desktop creates visuals it aggregates your data into chunks, or groups, based on values it finds in the underlying data. Often that's fine, but there might be times when you want to refine how those chunks are presented.
For example, you might want to place three categories of products in one larger category or group, or you might want to see sales figures put into bin sizes of 1,000,000 dollars instead of chunks of 923,983-dollar sizes.
In Power BI Desktop, you can group data points to help you more clearly view, analyze, and explore data and trends in your visuals. You can also define the bin size to put values into equally sized groups that better enable you to visualize data in meaningful ways. This action is called binning.
To use grouping, select two or more elements on a visual by using Ctrl+Select. Then right-click one of the selected elements, scroll to Group, and choose Group from the context menu.
Once it's created, the group is added to the Legend well for the visual with (groups) appended. The group also appears in the Fields list.
Once you have a group, you can edit its members.
Nota
You can create groups for any field in the Fields well, without having to select multiple items from an existing visual. Just right-click the field and select New group from the menu that appears.
Use binning to right-size the data that Power BI Desktop displays. You can set the bin size for numerical and time fields in Power BI Desktop. You can make bins for calculated columns but not for measures.
To see binning in action, take a look at this video.
And that's all there is to using grouping and binning to ensure the visuals in your reports show your data just the way you want them to.
You might also be interested in the following articles:
Avvenimenti
Kampjonati tad-Dinja Power BI DataViz
Feb 14, 4 PM - Mar 31, 4 PM
B'4 ċansijiet biex tidħol, tista 'tirbaħ pakkett ta' konferenza u tagħmilha għall-Grand Finale LIVE f'Las Vegas
Sir af aktarTaħriġ
Ċertifikazzjoni
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.
Dokumentazzjoni
Show items with no data in Power BI - Power BI
Learn how Power BI behaves when determining relevant data, and how it handles and displays items with no data.
Expression-based titles in Power BI Desktop - Power BI
Create dynamic titles in Power BI Desktop that change based on programmatic expressions, using conditional programmatic formatting.
Sort one column by another column in Power BI - Power BI
Learn how to change the look of a Power BI visual by sorting it by data fields. Use one column to define the sort order of another column.