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
    • Partners Overview
    • Solutions Partners
    • BI Specialized Partners
    • Power BI CSOs
    • Fabric Partner Community
    • Training
    • 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
    • Power BI forums
    • Updates
    • 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 forums
    • 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: 

    Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

    • Power BI forums
    • Galleries
    • Data Stories Gallery
    • Income Statement Design

    Income Statement Design

    05-25-2023 05:37 AM

    Zubair_Muhammad
    Community Champion
    1546 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    Zubair_Muhammad
    Zubair_Muhammad Community Champion
    Community Champion
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Income Statement Design

    ‎05-25-2023 05:37 AM

     

    eyJrIjoiOGY5MDA5NmYtNGJhMS00ODM0LWIxMGItOTdlZmI1MDA4ZWI0IiwidCI6Ijk0ZDcxMDE2LTIzNTctNDM3MS1iY2Q5LWY0OWRjNjdjMTcxMSIsImMiOjl9&pageName=ReportSection05d170e249d9d28c69b3


    Regards
    Zubair

    Please try my custom visuals
    • Hierarchical Bar Chart
    • Multiple Sparklines
    • Cross the River Game
    Labels:
    • Labels:
    • Business
    Message 1 of 9
    1,546 Views
    0
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    RenanLS
    RenanLS
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎06-02-2023 09:30 AM

    Hello again, I have a question.

    I have been using your chart on my company, it was awesome, but I have a question, I have used the waterfall graph to show the Income Statement of each client, and as I select on the slicer a month the graph show me the data of that month... Problem is, when there is no month selected it shows me a value that I do not know what is... It is not the sum of all the months (too low to be that), not the average... I have no idea of what is being shown when there is no month on the filter. Can you explain me what the graph do in thsi scenario?

    Thank you.

    Message 7 of 9
    1,080 Views
    0
    Reply
    Zubair_Muhammad
    Zubair_Muhammad Community Champion
    Community Champion
    In response to RenanLS
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎06-03-2023 04:24 AM

    Hi Renan,

     

    Could you send me sample pbix file at zubair@excelnaccess.com. Would love to see whats going on.

     


    Regards
    Zubair

    Please try my custom visuals
    • Hierarchical Bar Chart
    • Multiple Sparklines
    • Cross the River Game
    Message 8 of 9
    1,048 Views
    0
    Reply
    RenanLS
    RenanLS
    Frequent Visitor
    In response to Zubair_Muhammad
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎06-07-2023 10:06 AM

    Hello. I cannot because it is a file of my company and we are not allowed to share it. But it is a rather simples thing, I think that the way you programmed the graph should answer it. Basically, I want to know what is shown up on the graph when no date is selected. So, for example, I have data from jan 2022 to abr 2023, all of this data is being brought to the graph, and when I use the slicer to select a specific month, the date from that month is what appear on the graph... Promblem is, when no month is selected on the slicer there is a number that I just don't know what is on the graph. I just want to know what is being shown when there is no date selected.

    Message 9 of 9
    899 Views
    0
    Reply
    RenanLS
    RenanLS
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-30-2023 12:22 PM

    Hello, I really liked this page. Can you tell me how you did those colums at the left side and what exaclt is on the x axis of the right graphs? Thnak you.

     

    Message 2 of 9
    1,250 Views
    1
    Reply
    Zubair_Muhammad
    Zubair_Muhammad Community Champion
    Community Champion
    In response to RenanLS
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-31-2023 04:13 AM

    Hi Renan,

    I am glad you liked it. Its built using my custom visual "Multiple sparklines". You can put anything on the Axis for example years, months, quarters for the trend sparklines
    This is just a rough template using random numbers.  More details on how to use this visual are in the webpage of this visual Multiple Sparklines – Power BI & Excel are better together (excelnaccess.com) 

     

     


    Regards
    Zubair

    Please try my custom visuals
    • Hierarchical Bar Chart
    • Multiple Sparklines
    • Cross the River Game
    Message 3 of 9
    1,224 Views
    0
    Reply
    RenanLS
    RenanLS
    Frequent Visitor
    In response to Zubair_Muhammad
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-31-2023 12:32 PM

    Helllo again. I have been trying to use your chart... I place the values on the line, bubble and so on, but literally nothing happens, only the "values" part work.

    Message 5 of 9
    1,164 Views
    1
    Reply
    Zubair_Muhammad
    Zubair_Muhammad Community Champion
    Community Champion
    In response to RenanLS
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-31-2023 10:08 PM

    Can you share your file with me on zubair@excelnaccess.com


    Regards
    Zubair

    Please try my custom visuals
    • Hierarchical Bar Chart
    • Multiple Sparklines
    • Cross the River Game
    Message 6 of 9
    1,145 Views
    0
    Reply
    RenanLS
    RenanLS
    Frequent Visitor
    In response to Zubair_Muhammad
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-31-2023 09:00 AM

    Thnak you very much.

    Message 4 of 9
    1,196 Views
    0
    Reply

    Power Platform

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

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • 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