Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
2.8 View Data and Export in CSV from Power BI Visuals | Power BI Tutorials for Beginners
Play lesson

Power BI Tutorial - 2.8 View Data and Export in CSV from Power BI Visuals | Power BI Tutorials for Beginners

4.0 (1)
9 learners

What you'll learn

This course includes

  • 3.5 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

#pavanlalwani #powerbi #dashboarddesign #dataanalytics In this video tutorial, we will learn how to view and export data Excel charts in a quick and efficient way. We will specifically focus on creating a stacked column chart and extracting specific data points from it. First, we will create a stacked column chart by selecting the "Subcategory" for the x-axis and "Sales" for the values. We will also include the "Region" as the legend. Next, we want to find the value of 71,000 for the West region and the "Storage" subcategory. Instead of manually filtering the data in Excel, there is a much faster method. Simply right-click on the desired bar and select "Show data point as table." This will give you the filtered data for that specific data point. If you want to export this data quickly, you can click on the three dots at the top and choose "Export data." This will save the filtered data as a CSV file, which can be easily shared with others. It's important to note that the ability to view and export data can be controlled through the file options and settings. You can choose whether to allow end-users to export summarized data or restrict their access. Overall, this method provides a fast and convenient way to view and export data directly from Excel charts, saving you time and effort. --------------------------------------------------------- 💼 Invest in your future with our Power BI 2023 NEW Course at an incredible 50% discount: 🔗 https://pavanlalwani.com/ 📚 200+ MCQs to test your knowledge. 📝 20+ Assignments for hands-on practice. 🔍 11+ Case Studies for real-world insights. 💼 5+ Industry Projects to build your portfolio. 🎓 Course Completion Certificate for your resume. 💡 Tips & Tricks to boost your skills. 🔎 5+ Industry Datasets for practical learning. Invest in yourself. Become a Power BI expert. The future is yours! 💼💪" 📥 Download Practice Material from Server 💾: http://bitly.ws/zZo4 #datacleaning #businessintelligence #powerbi #powerbitraining #microsoftpowerbi --------------------------------------------------------- Timestamps: 00:00:03 Creating a Stacked Column Chart 📊 00:00:16 Adjusting Visualization and Adding Labels 📊✏️ 00:00:42 Finding the Value of 71,000 in West Region and Storage 💡 00:01:12 Comparing Traditional and New Method of Data Filtering ⚖️ 00:01:33 Filtering Data Points and Exporting as CSV 📂 00:02:01 Exporting Data for Sharing with Colleague or PLY 💻📧 00:02:26 Changing Permissions and Access for End Users 🔐👨‍💻 00:02:56 Disabling End User's Ability to Export Data ❌📤 00:03:21 Accessing Report Settings and Export Data Options 📑⚙️

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere