Forum Discussion
Solved
why does value in visualisation prefix first
Hi This might be a strange and easy question to answer but I have looked extensively on the community and the web and can't seem to find a solution to why the values in a visualisation prefic wit...
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
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.
That's fantastic, I will spend some time maing sure I know exactly how this measure works (I have so much to learn!!!)