skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Microsoft 365 + Power BI
    • Dynamics 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Getting started
      • Overview
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Microsoft Power BI Community
    • Welcome to the Community!
    • News & Announcements
    • Get Help with Power BI
    • Desktop
    • Service
    • Report Server
    • Power Query
    • Mobile Apps
    • Developer
    • DAX Commands and Tips
    • Custom Visuals Development Discussion
    • Health and Life Sciences
    • Power BI Spanish Community
    • Translated Spanish Desktop
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Training and Consulting
    • Instructor Led Training
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    • Ideas
    • Custom Visuals Ideas
    • Issues
    • Issues
    • Events
    • Upcoming Events
    • Community Engagement
    • T-Shirt Design Challenge 2023
    • Community Blog
    • Power BI Community Blog
    • Custom Visuals Community Blog
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Data Stories Gallery
    • Re: Sales & Returns Sample Report

    Re: Sales & Returns Sample Report

    12-20-2019 00:28 AM

    Anonymous
    Not applicable
    84630 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    tessahurr
    Microsoft tessahurr
    Microsoft
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Sales & Returns Sample Report

    ‎12-16-2019 09:33 AM

    We're excited to introduce a new Power BI sample report for you to play around with. This report includes new features, shows designs factors you should take into consideration when building a report, and has been optimized Power BI Desktop, service, and mobile. You can see how visuals from AppSource can be added to your reports, how they work well with other Power BI visuals, and learn how the Power Apps visual can be used in a report.

     

    Read more about the Sales & Reutrns sample report on our blog!

     

    eyJrIjoiOWZlMTRjYTQtNzRkYS00ZDUyLWI4Y2EtMDdkZTM0ZjIxZWViIiwidCI6IjcyZjk4OGJmLTg2ZjEtNDFhZi05MWFiLTJkN2NkMDExZGI0NyIsImMiOjV9

    Preview file
    317 KB
    Sales & Returns Sample - Dec 2019.pbix
    Labels:
    • Labels:
    • How To
    Message 1 of 18
    88,711 Views
    39
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    rbalasakuri
    rbalasakuri
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-19-2023 04:36 AM

    can i have the below files which are mentioned in the datasource for this report

     

     

    a. C:\Users\mimyersm\Desktop\Sales & Marketing Datas.xlsx

    b. C:\Users\mimyersm\Dropbox\Data-27-09-2019.xlsx

     

    Message 18 of 18
    2,124 Views
    0
    Reply
    Anonymous
    Not applicable
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-27-2020 02:53 PM

    Hi,

     

    I am a beginner in PowerBI. Is the raw data used for this report available anywhere? 

     

    Thanks in advance

    Message 17 of 18
    49,500 Views
    0
    Reply
    emmasaunders
    emmasaunders
    Regular Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎11-16-2020 06:35 AM

    I am building a course on MS PowerBI and trying to teach students the first part of the course using this sample report. I am experiencing several errors in the report. Could they be corrected? (Or please advise if it is me. Firefox wasn't working great so I'm on Chrome, using a Mac.) (1) On Page 2 (Intro), the three circles don't work (error: too few arguments in imageURL bucket). (2) On page 3 (Net Sales), the decomposition tree doesn't show. Does every end user really need to have this preview feature switched on via Desktop? (3) And most of the hidden pages don't show any content in Edit Mode, e.g. WhatIf tab. They all have the error: "too few columns in imageURL bucket". Is this expected behaviour? Thanks for any help.

    Message 16 of 18
    49,545 Views
    0
    Reply
    Maignan
    Maignan Helper III
    Helper III
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎06-22-2020 10:28 AM

    There is an error message on first page of the report, on the left. Please correct it please. There seems to be an issue with the version of SQL Server Analysis

    Message 15 of 18
    49,977 Views
    0
    Reply
    Meagan
    Meagan Advocate IV
    Advocate IV
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎02-05-2020 01:19 PM

    While this report does show some nice features of Power BI, it is once again another demo report that is not accessible. 

    A quick browsing of the report tells me:

    • tab order is not set and decorative shapes are not hidden in the tab order
    • there are color contrast issues with the light blue text on the blue background
    • there are color contrast issues with the light gray bars on the white background
    • No alt text has been set on visuals and the titles of the visuals are not very descriptive

    The best thing I can say for it is that it seems to be mostly colorblind friendly due to the use of only a few couple of colors on each page and not combining red/green, etc.

    I would love to see a nice demo report from Microsoft that even makes an attempt at basic accessibility. Maybe this one could be updated to do so? We have the features, there is documentation to teach people how to do this if they haven't already learned. 

    Message 12 of 18
    50,284 Views
    2
    Reply
    cabc_xlorla
    cabc_xlorla Advocate IV
    Advocate IV
    In response to Meagan
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎08-14-2020 08:53 AM

    @Meagan you make some great observations.

    Question; for the colorblind friendly techniques or palettes, which ones do you prefer?

    Thanks!

    Message 13 of 18
    49,834 Views
    0
    Reply
    Meagan
    Meagan Advocate IV
    Advocate IV
    In response to cabc_xlorla
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎08-14-2020 09:12 AM

    I almost always make my own palette rather than using a built-in one, but that is just because I am rather particular. If I don't have an organizational color palette to work from, I usually default to blue and gray or use viridis as inspiration. Lately, I'm enjoying using the free Adobe color tool to check my palettes for color blindness conflicts. But I also still just grab screenshots and put them in Coblis as another check. There are also browser extensions to help you check color blindness and other color contrast issues. I did check the first five colors of the default palette and they were ok as far as most types of colorblindness, and all colors had sufficient contrast to be used in charts against a white background. See this tweet for more info.

    Message 14 of 18
    49,831 Views
    2
    Reply
    bash243
    bash243
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-25-2019 05:09 AM

    the bookmark navigation you had used is not working at design time, is this normal behaviour?

    Message 11 of 18
    83,916 Views
    0
    Reply
    Anonymous
    Not applicable
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-25-2019 12:33 AM

    Great design ideas. Thanks for sharing. 

    Message 10 of 18
    83,937 Views
    0
    Reply
    kentyler
    kentyler Solution Sage
    Solution Sage
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-20-2019 09:54 AM

    Thanks for the very interesting sample.

    It does a great job of highlighting the new features of Power BI.

    It does a less great job of being a report. It does include links to decomposition tool, but otherwise seems focused on presenting single meaningful number about current sales.
    It is hard for the user to understand whether these numbers fall within the normal variation for sales and returns or whether they are significantly higher or lower than their normal range. Without this context it's hard for the user to assess the impact of what they are seeing.





    Did this post answer your question? Mark it as a solution so others can find it!

    Help when you know. Ask when you don't!




    Join the conversation at We Talk BI find out more about me at Slow BI


    Message 9 of 18
    84,509 Views
    1
    Reply
    Anonymous
    Not applicable
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-17-2019 06:58 PM

    Hi,

     

    Thanks for sharing and I think your report is amazing.

    The Q&A visualization in the "Net Sales" and "Returns" page is not showing on the right hand side if I view the report in Chrome / Edge / Firefox. If I download the file and open it using Power BI Desktop, those two Q&A visuals can be displayed properly.

    Just wonder if this is a bug when viewing this visual in Power BI Service? Or maybe due to brower setting issue?

     

    Best regards,

    Emily

    Message 2 of 18
    85,775 Views
    0
    Reply
    tessahurr
    Microsoft tessahurr
    Microsoft
    In response to Anonymous
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-19-2019 10:57 AM

    Hi Emily,

     

    It turns out that the Q&A visual doesn't work yet with Publish to Web.  If you download the report and upload it to your own workspace on the service you should see it working there.

     

    Thanks,

    Tessa

    Message 4 of 18
    84,761 Views
    0
    Reply
    SamSPAIN
    SamSPAIN
    Frequent Visitor
    In response to tessahurr
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎03-04-2020 09:53 PM

    Hi @tessahurr , would be possible for Microsoft PBI team to post at some point the end-to-end video that recreates this report? Thanks a lot

    Message 8 of 18
    50,220 Views
    1
    Reply
    Anonymous
    Not applicable
    In response to tessahurr
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-20-2019 12:28 AM

    Ok got it, thank you Tessa 🙂

     

    Best regards,

    Emily

    Message 7 of 18
    84,630 Views
    0
    Reply
    nagaraj007
    nagaraj007 Post Patron
    Post Patron
    In response to tessahurr
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-19-2019 11:21 PM

    Hello All,

     

    Could some one share the video of this PBIX file. I am finding difficult to replicate the same for the bookmarks used in CLOSE ICON.

     

    Regards

    Nagaraj

    Message 5 of 18
    84,652 Views
    2
    Reply
    SamSPAIN
    SamSPAIN
    Frequent Visitor
    In response to nagaraj007
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎01-12-2020 07:41 AM

    Hi there! I'm a newbie to the PBI Community. I wondered if end-to-end video to replicate this report has been posted somewhere. I myself am working on a Daily Sales reporting for my employer and would love to incorporate some of this stuff this report contains. Big thanks in advance

    Message 6 of 18
    82,055 Views
    0
    Reply
    tessahurr
    Microsoft tessahurr
    Microsoft
    In response to Anonymous
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-18-2019 09:29 AM

    Hi Emily,

     

    Thanks for bringing this to my attention.  I'll look into the issue and hopefully we can get it resolved quickly.

     

    Thanks,

    Tessa

    Message 3 of 18
    85,262 Views
    1
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices