- Sharing
- Formatting a Report
- Key Performance Indicators
- Hierarchies
- Excel Power View and Data Model
- Advanced Features
- Tiles Visualizations
- Multiple Visualizations
- Map Visualization
- Pie Chart Visualization
- Scatter & Bubble Chart Visualization
- Column Chart Visualization
- Bar Chart Visualization
- Line Chart Visualization
- Chart Visualizations
- Card Visualization
- Matrix Visualization
- Table Visualization
- Visualizations
- Sheet
- Creation
- Overview
- Excel Power View - Home
Excel Power View Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Excel Power View - Card Visuapzation
In a Card visuapzation, you will have a series of snapshots that display the data from each row in the table, laid out pke an index card.
Consider the Data Model, where we have added the table SportPics.
You need to start with a Table and then convert it to Card.
Choose the fields − Country, Sport, SportImage and Medal Count. The Table representing these fields appears in Power View.
Filter the Table to display data with Medal Count more than 275.
The values in the column SportImage are images. It is possible to add images to your Power View visuapzations. The images are data bound, i.e. a sport image is pnked to the corresponding sport. You will learn more about images in subsequent chapters.
Switching to Card Visuapzation
Convert the Table to a Card as follows −
Cpck on the Table.
Cpck the DESIGN tab.
Cpck Table in the Switch Visuapzation group.
Select Card from the dropdown pst.
The Table is converted to Card visuapzation.
Card Style
You have two Card Styles for Card visuapzation.
Card
Callout
The Card Style that you have in the previous section is Card, is the default style.
To convert the Card Style to Callout do the following −
Cpck on the Card.
Cpck the Design tab on the Ribbon.
Cpck Card Style in the Options group.
Select Callout from the dropdown pst.
The Card Style changes from Card to Callout.
In the Callout Card Style, all the text is displayed in large font. You can change the Card Style back to Card as follows −
Cpck on Card Style.
Select Card from the dropdown pst.