Income Statement Design 05-25-2023 05:37 AM

[Zubair_Muhammad]

eyJrIjoiOGY5MDA5NmYtNGJhMS00ODM0LWIxMGItOTdlZmI1MDA4ZWI0IiwidCI6Ijk0ZDcxMDE2LTIzNTctNDM3MS1iY2Q5LWY0OWRjNjdjMTcxMSIsImMiOjl9&pageName=ReportSection05d170e249d9d28c69b3

[RenanLS]

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.

[Zubair_Muhammad]

Hi Renan,

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

[RenanLS]

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.

[Zubair_Muhammad]

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) 

[RenanLS]

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.

[Zubair_Muhammad]

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

[RenanLS]

Thnak you very much.