Exam 70-778 topic 1 question 59 discussion

Shoud be C

I agreed the answer must be C

Agree with C as the reason it is counting is possibly due to the field being a string/text

Agree with C.

B is wrong because it will sum the values, if its a measure it will work So i am going with C I tested and it works fine, even there is no data type called Numeric

at first I went with B (not really a good choice becoz it will make the whole file become bigger unnecessarily), after I read the discussion I went with C. becoz if it’s numeric #, every time when we do implicit measure, it will get an auto “Sum”, the only exception is when the underlying dataset’s column actually is of a format of “text”. Therefore, I think C is correct.

TRICK QUESTION: The question states "modify the query" - so the answer has to be (B) which has Power Query Editor, it would work but its not pretty. The 'Data' type option doesn't include a 'Numeric' option because the actual word refers to of numbers, your data type option for numbers would be, whole number, decimal number, or fixed decimal number so option C - can't be correct.

A is ridiculous. B can't be done in the Query Editor. D doesn't change anything. C is the only choice left. Plus it works.

C. https://www.reddit.com/r/PowerBI/comments/6x68od/why_power_bi_in_line_chart_shows_only_counts/

the question says: You need to modify the query to ensure that the data appears correctly. The only option to modify the query is B. C also works, but by changing Summarization (Count -> Sum), not only by changing Data type. Tricky question indeed.

Definitely C

Wow, this is a trick question if ever there was one. I agreed with everyone. It can be either B or C to be honest. B can be demonstrated here [https://radacad.com/why-my-values-are-not-showing-correctly-in-power-bi]. Now here is where I'm like... oh man, I don't know... is if the Answer C is actually saying that Numeric is its' own Data Type, then NO there is no Data type that is "Numeric" therefore B would be correct, but in practice you would go and check if Power BI has identified the Values as SUM and not COUNT. Admin please review as this can be very easily misunderstood.

Correct Answer is C. Change the Data Type of sales amount column to Numeric.

If in a Bart chart your value is automatically displayed as a count it means that the data type of your value is not numerical (it might be text or else….). Hence if you change the type of your data in query (from text to decimal or whole number) your data should automatically appear as a sum on your bar chart. I tried it. Hence to me C is the correct answer.

there is no Numeric data type in Power BI...

Agreed this one is C... Ran into this issue at work and couldn't figure out what was going on for the longest time

C is correct