You are building a data model for a Power BI report. You have data formatted as shown in the following table. You need to create a clustered bar chart as shown in the following exhibit. What should you do?
A.
From Power Query Editor, split the Machine-User column by using a delimiter.
B.
From Power Query Editor, create a column that contains the last three digits of the Machine-User column.
C.
In a DAX function, create two calculated columns named Machine and User by using the SUBSTITUTE function.
D.
In a DAX function, create two measures named Machine and User by using the SUBSTITUTE function.
Agree with A.
Only reason I had for not using B was that we may not be able to guarantee a length of 3 char.
Has anyone else got a reason for not choosing B?
Its wrong if you split the column at Powerquery the name of the columns dont split then we need the name to make the legend and the y labels so the correct choice is C
we use SUBSTITUE function for: Replaces existing text with new text in a text string.
but here we do not want replace something, we want split the column by the delimiter "-"
If we split the column, we might never be able to use the original. Also, the question does not say to maintain the model size. So the best answer should be B.
A is the correct answer.
This action will allow us to split the combined "Machine-User" values into separate columns for "Machine" and "User", which is for creating a clustered bar chart with the desired X and Y-axis values.
Answer is A is the best and fastest solution. Splitting the column into 2 is better that creating an extra 2 calculated columns, this will increase the model size.
The desired visual is provided. However, the dataset shown contains a column where machine and user data from the visual are combined into 1 column. Therefore, to solve this you need to use a delimiter. This will split one column into two, where you will use Machine column (BAC & ABC) as your Y-axis and User column (123 & 657) as your legend.
The desired visual is provided. However, the dataset shown contains a column where machine and user data from the visual are combined into 1 column. Therefore, to solve this you need to use a delimiter. This will split one column into two, where you will use Machine column (BAC & ABC) as your Y-axis and User column (123 & 657) as your legend.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Namenick10
Highly Voted 2 years, 2 months ago1CY1
2 months, 3 weeks agonevesrf
1 year, 10 months agoShalaleh
1 year, 8 months agoShalaleh
1 year, 8 months agoSamuComqi
Highly Voted 1 year, 4 months agoMoxieTT
1 year, 4 months agoAdrianBalescu
12 months agoFra04
9 months, 2 weeks agodesibaby09
Most Recent 4 days, 2 hours agojaume
3 weeks, 5 days agorcaliandro
3 months, 4 weeks agoDsbuff
12 months agoSandeep_kumar_yadav
1 year agolcss27
1 year, 3 months agoIgetmyrole
1 year, 3 months agoMoxieTT
1 year, 4 months agoShalaleh
1 year, 7 months agoUlyUkr
1 year, 7 months agoRazaTheLegend
1 year, 8 months agoShaziq
1 year, 11 months agonaomilena
1 year, 11 months agojboiret
2 years agocsillag
2 years agoPatrick666
2 years ago