Forum Discussion

brandondg2017's avatar
brandondg2017
Regular Visitor
3 years ago
Solved

ODBC Connecting to QuickBooks Desktop

Hello, I am in need of help with this. I am a little new with Power BI and using a ODBC connection. I have it all connected with my QuickBooks file and can import data into Power BI. If you know any...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi brandondg2017 ,

    Please create a new measure like.

    Total = SUM('Table'[Sales]) + SUM('Table'[Profit])

    And then add a clustered column chart. or consider use starcked column chart with 2 measures.

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

brandondg2017's avatar
brandondg2017
Regular Visitor
3 years ago

No I want the Sum of Sales and sum of Profit to be one. In my case It is sum of Credit Card Charges and Sum of Bill to get one expense column not seperate ones. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi brandondg2017 ,

Please create a new measure like.

Total = SUM('Table'[Sales]) + SUM('Table'[Profit])

And then add a clustered column chart. or consider use starcked column chart with 2 measures.

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum