Exam 70-778 topic 1 question 33 discussion

It should be matrix

KPI visual cannot list multiple rows. Only way to achive that is by creating a calculated column to return an image URL, and then adding that to a table. So the correct anwser should be D

Have to read the question very carefully....It's not asking to create a visual that looks like the model being exhibited. It's asking to create a visual (any visual) that is "based on" the model being exhibited.

Should be A - Matrix. https://www.biinsight.com/use-kpi-in-table-matrix-and-card-visualisations-in-power-bi/#more-4478 In a Table we will not have empty lines formatting for Year column.

The answer is Matrix with conditional icons to replicate what referred to as KPI in Power Pivot.. easy peasy

layout like this with "Status" Column, 1000% related to KPI, I tested when I prepare for 779 exams. B is correct.

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-import-and-display-kpis

The question stipulates a KPI already exists; it then goes on to state: "You need to create a visualization based on the Power Pivot model as shown in the exhibit. (Click the Exhibit button.)" The model shown lends itself to a matrix.

It should be table, not matrix, because in Matrix if you add second dimension, headers are replaced with many columns each column header with it's value, but here we see two columns headers, so column adds more cols not rows ...so should be table.

The matrix automatically aggregates the data and enables drill down. You can create matrix visuals in Power BI Desktop reports and cross-highlight elements within the matrix with other visuals on that report page. For example, you can select rows, columns, and even individual cells and cross-highlight.

Matrix can be used easily

The status it has is only possible in matrix and not any other. so please check your answer.

The question states : You need to create a visualization based on the Power Pivot model ....ie KPI and hence KPI seems to be correct answer. It is very tricky question.

Answer is A. Matrix. https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual#add-conditional-icons

To conclude, the answer is certainly Matrix, which is same as Excel PivotTable in PowerBI, but it also has the functionality of conditional formatting. If this question is for the Excel exam, then the answer is KPI in order to display the conditional formatting like that.

The answer makes my head hurts. It literally tells you what you need to do here: https://www.biinsight.com/use-kpi-in-table-matrix-and-card-visualisations-in-power-bi/ To meet the requirement of the question "You need to create a visualization based on the Power Pivot Model as shown in the exhibit" - my understanding....make a visual that looks like the exhibit in Power BI. Creating a KPI which is a Card Visual in the Report DOES NOT LOOK LIKE THE EXHIBIT!! I have tested this over and over and over. It doesn't work on the Matrix Visual works. The answer either assumes that I have already put down some form of visual for me to ADD a KPI for a Multi-card visualization. Or there "apparently" is a way for me to create tables and conditional formatting KPIs grouped by Year that I am not aware of...(if so please tell me. I NEED TO KNOW!!). End rant.

"You have a Power Pivot model that includes a KPI" so I should have read this as visualize the KPI from the Power Pivot. Is this testing Power BI or my reading comprehension.