Forum Discussion
why does value in visualisation prefix first
Hi Qualube,
Not really sure of what you mean with your question.
Are you refering that when you place a text value on a table and select the First as a summarization the total colum shows the first value of the table?
If this is the question you need to understand that when you make a summarization of any value in Power BI the context influences the result, so when you have a table and you had the text to your table and several other columns you will get the first value that is influenced by the values on that row, the value is filtered by the other lines.
When you get to the total since the context changes and you are looking at the full dataset included in that particular table visual you will get the first value of the table.
Regards,
MFelix
Hi MFelix
I have been learing about row & filter context but I don't know how to stop it happening or more precisely how to alter the context to stop it happening.
Hi Qualube,
This can be done in several ways depending on the expected end result.
You can remove the totals from your table, but this will take out from all columns and only one, add a measure that removes the total line would be something like this:
FIRST CUSTACCOUNT= IF ( HASONEVALUE ( Table[CUSTACCOUNT] ); FIRSTNONBLANK ( Table[CUSTACCOUNT]; TRUE () ); BLANK () )Be aware that this measure may be need to changed accordingly to expected result.
Regards,
MFelix
Hi
Thanks so if I understand correctly the recommended measure will only remove the CUSTACCOUNT total and leave the rest intact?
Correct,
You need to replace the CUSTACCOUNT column by this measure.
Regards,
MFelix
Hi
Tried that but as you said it removes all totals I only wish to stop the text being listed in the totals.
I only have the following options on the value in the visualisation.