Atvik
Heimsmeistaramót Power BI DataViz
Feb 14, 4 PM - Mar 31, 4 PM
Með 4 tækifæri til að taka þátt gætirðu unnið ráðstefnupakka og komist í LIVE Grand Finale í Las Vegas
Nánari upplýsingarÞessi vafri er ekki lengur studdur.
Uppfærðu í Microsoft Edge til að nýta þér nýjustu eiginleika, öryggisuppfærslur og tæknilega aðstoð.
APPLIES TO:
Power BI Desktop
Power BI service
Small multiples, or trellising, splits a visual into multiple versions of itself. The versions are presented side by side, with data divided across these versions by a chosen dimension. For example, a small multiple could split a "sales by product" column chart across countries/regions or customer segments.
For live connected data models, this feature requires a version of AS, which supports the second generation of DAX queries, also known as SuperDAX: for tabular models, AS 2016 or newer; and for multidimensional models, AS 2019 or newer.
Currently, you can create small multiples on bar, column, line, and area charts.
To get started, create one of the above visuals and choose a field along which you'd like to partition its data. Drag that field into the Small multiples well in the Fields section of the Visualizations pane.
Your chart splits into a two by two grid, with the data divided along your chosen dimension. The grid fills with the small multiples charts. They're sorted by your chosen sort order, from left to right, then top to bottom.
You see that the axes are synchronized. There's one Y axis at the left of each row, and one X axis at the bottom of each column.
Now that you created small multiples, see how you Interact with small multiples in Power BI.
Some options in the formatting pane let you control the look and feel of the grid.
You can change the dimensions of the grid in the Small multiples card:
The default is a two by two grid of small multiples, but you can adjust the number of rows and columns up to six by six. Any multiples that don't fit in that grid, load as you scroll down.
As with other visual titles, you can adjust the style and position of the small multiple titles in the Small multiple title card.
Here are some current limitations.
General
Axis
Total labels
Zoom slider
Analytics pane
Let us know your thoughts about the small multiples visual:
Atvik
Heimsmeistaramót Power BI DataViz
Feb 14, 4 PM - Mar 31, 4 PM
Með 4 tækifæri til að taka þátt gætirðu unnið ráðstefnupakka og komist í LIVE Grand Finale í Las Vegas
Nánari upplýsingarÞjálfun
Eining
Model data in Power BI - Training
Connect Power BI to multiple data sources to create reports. Define the relationship between your data sources.
Vottorð
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.
Skjöl
Scatter, bubble, and dot plot charts in Power BI - Power BI
Learn how to use scatter charts, dot plot charts, and bubble charts in Power BI Desktop and the Power BI service.
Waterfall charts in Power BI - Power BI
Learn how to create and configure waterfall charts in the Power BI service and Power BI Desktop.
Table visualizations in Power BI reports and dashboards - Power BI
Learn how to work with table visualizations in Power BI reports and dashboards, including how to resize column widths.