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

#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:

📚 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.

Join thousands of professionals who have transformed their careers. Enroll now at 50% off!
You can also explore our Power BI DAX 2023 course and get a 360º understanding of DAX

Invest in yourself. Become a Power BI expert. The future is yours! 💼💪"

#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 📑⚙️

[PavanLalwani]

🚀 Calling all data enthusiasts! 💼🌟

👉 Discover the power of Power BI with our Specialization course at a jaw-dropping 50% off!


💥 Level up your analytical game and supercharge your career with the Power BI DAX course. 💯💼

[Pranaviabhiramvlogs]

After a long gap, I just completed my Degree by encouragement of my Husband and I am very much intrested in learning Power BI only from u for my career with this course.
Thank you for providing valueable course as free .
Thank you again Pavan Sir.

[HareKrsn]

Your concepts are short and to the point which saves my time to learn concepts in power BI....Thank you Sir!!

[xenos]

You make the best tutorial on Youtube.
Respect for you.

[nishiraju]

Very Informative. Very Simple and clear Understandable....
I would request you to please keep uploading more n more video ..
Thank you So much Sir .

[rabaaalimassoud]

Very Informative, very Simple and clear .
Thanks .

[shashankgupta]

Short video is great for us to find out some issues in particular topic.
And thanks for your video sir, I appreciate it.

[vyasghat]

Thank you for explaining very clearly and it really helped me...

[SonuPandey-mefs]

Great feature as always the management person whose background is excel they always wants to active this feature. I have one question here, Is there any option to control the column level restriction that if we want to share only some of columns in any particular sequence?

[avirajankitjain]

This is amazing that u picking every concept in every video of 2 or 3 min. Isn't it possible for u to make a video of somewhat lengthy and able to pick 3 or 4 concept in single video.

[vishalparyani]

HI can you please let me know from where can I download the data set which you are showing in youtube so that I can practice along with you....

[kabhi]

Can you please share how the 2nd option to allow data access & download option is different from the default option 'View data & Download'? I've tried it & the downloaded data seemed to be similar to the first, default option?

[dxiwkkn]

Are you providing online classes now for Power bi please reply

[zgjqbij]

Hi ..
Is it work for all the visuals.. when I tried with line and staked line chart .. the option 'Show data point as a table'

Can you please tell us if there are any limitations !!
Thanks in advance 😊 .

[saiabhishekk]

Sir for me it is showing both the x axis and y axis when we click the stacked chart

[sivakrishnachoppa]

One question on Report settings under Current file, Is it applicable only for particular page (2.8) in file or it applicable for all pages?

[kumkumsaini]

Hello Sir, well and deep explained by you, I am unable to download the data for practice from that link provided by you in the description. When I clink on that link, it takes me to the drive. Please help me out.

[shivamgupta-vgtz]

How to delete or add columns value in data point as a table

[shyamsonharshadeeppatcha]

Can i know why most of the numbers are missing in the playlist.. like 2.9 is missing 3.0 is missing? Any one reply please!!

[aishwaryawandhe]

Unable to find value option on my dashboard.