• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power Bi to excel export

P

PowerBiKitten

New Member
How do I get the columns to be consolidated? The power bi publish file to excel "example for forum" is not correct. The "IQDQCI" file shows how I'd like my commitment tab to look like. The number is consolidated instead of a whole bunch of numbers I dont recognize pulling in. I added relationships in power bi. So what is happening.
 

Attachments

As You have read from
K

Thread 'Site Rules - New Users - Please Read'

Hi all,

Welcome to the Chandoo.org Forums.

Posting Rules & Etiquette

The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge.

The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in.

Please take a few minutes to read this list of Rules, Procedures and Etiquette's for posting here at the Chandoo.org Forums.

How to get the Best Results at Chandoo.org
  • Use Relevant words in the Title and in the tag Box, This will aid future searches...
  • Like
  • Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
  • If you do cross-post, please put that in your post.
  • Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.
 
You were told in the other forum what the issue was. Without seeing the model, it is impossible to say why the values are coming through as text, but that's what you need to fix so that you can put the data in the values area. It's too late once the data is in Excel.
 
You must log in or register to reply here.
Back
Top