Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

add total column at the end of bar chart

  • 1.  add total column at the end of bar chart

    Posted 26 days ago
    Hi

    I am kinda new to POWERBI and have been tasked to create a report/graph that shows values for every month of the year and instead of drilling down/up to see values for entire year the business would like to have all months next to each other and a totals column at the end of the graph.

    Is that possible? I have been butting my head against the wall for this for several days now

    ------------------------------
    Jacob van Zanen
    DBA
    MIRANDA
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: add total column at the end of bar chart

    Top Contributor
    Posted 26 days ago
    Will something below works for you? to have total at the year-end
    ?

    ------------------------------
    Farhan Ahmed
    Senior Business Intelligence Consultant
    karachi
    3452523688
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: add total column at the end of bar chart

    Posted 25 days ago
    Yes, that would be it...

    I can make my query return all the data required and use dummy columns for sorting and labels but that makes my query not as efficient as it should be

    Regards

    ------------------------------
    Jacob van Zanen
    DBA
    MIRANDA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: add total column at the end of bar chart

    Posted 25 days ago
    I am looking to do the same thing! For my situation, the chart you show is exactly what I would like to do.

    ------------------------------
    Caite Stevens
    Senior Vice President
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: add total column at the end of bar chart

    Top Contributor
    Posted 25 days ago
    Edited by Farhan Ahmed 25 days ago
      |   view attached
    Kindly refer to this file and let me know if this helped you guys!!!!

    ------------------------------
    Farhan Ahmed
    Senior Business Intelligence Consultant
    karachi
    3452523688
    ------------------------------

    Attachment(s)

    pbix
    TotalCalendar.pbix   30K 1 version
    Academy - Online Interactive Learning from Experts


  • 6.  RE: add total column at the end of bar chart

    Posted 24 days ago
    Interesting - this is exactly what I needed. Thank you for sharing it, I'll hold on to it so I can replicate it.

    ------------------------------
    Caite
    ------------------------------

    Academy - Online Interactive Learning from Experts